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: > 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, using > "format" option we can change it into required text format but this not > possible if my sheet contains thousands of such values. > > Please assist me in this regard. Have a great day...! > > Thanks in advance, > Nagi > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
