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 format. If you are using excel 2007 and you have some table type of format for entering data, you can select all data and from insert tab click on table. After you create a table, and if you set the format for all above rows, it will automatically follow the above format and you will not need to set format again and again. I am using the same thing in a tables with thousands of rows, it works fine and in my case format is more difficult to set again and again, but in this way it works well. Regards, Aditya Mundra
On Wed, Dec 3, 2008 at 1:59 AM, Tom Jeffries <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
