Before typing any such number you can use apostrophe ( ' ). This will solve
your problem.
On Mon, Dec 1, 2008 at 7:32 PM, kondaveti wrote:
> Hello all,
> When I am trying to write text "6-5", EXCEL automatically converting it
> into "5-Jun". How can I change this setting globally. As I know, u
But the problem will be that it will always convert to text. And date
functions will not work. The only way to work will be changing the format of
1000's of cells. You can select all cells in which data is there and in
which you want to put data together and just once you will need to change
the fo
a solution to your problem is to precede the numeric string with a single
quote ' . For example '6-2 will show the text sting 6-2 while 6-2 (without
the single quote) gives 1-Jun. Not very elegant but it seems to work.
Tom
On Mon, Dec 1, 2008 at 9:02 AM, kondaveti <[EMAIL PROTECTED]> wrote:
> H
Thanks Aditya for letting me know but this is not useful when we have 1000s
of such occurrences. Could you please suggest about it?
Nagi
On Tue, Dec 2, 2008 at 12:23 PM, aDiTyA <[EMAIL PROTECTED]> wrote:
> If you have a single column where you want such date format, than select
> that column and
If you have a single column where you want such date format, than select
that column and change format to the format you want.
Regards,
Aditya Mundra
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post t
