Before typing any such number you can use apostrophe ( ' ). This will solve your problem.
On Mon, Dec 1, 2008 at 7:32 PM, kondaveti <nagikondav...@gmail.com> 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 -~----------~----~----~----~------~----~------~--~---
