|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 28th, 2010, 11:05 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Dates in excel
I have about 2000 rows (x4 in columns) of dates in 2 formats and they are
"0/00/00 and 00/00/0000". How can I quick fix this problem into just one format for all like this way "00/00/00"? I tried using the formula and it did not help at all and the other way was for me to use "format cells, category-date, type-00/00/00”. Then, after I have to manually go into each cell and double click it and that the only way it will format it. Please help there must be an easier way to fix this problem. 
|
|
#2
May 28th, 2010, 11:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Dates in excel
Try DataText To Columns and tab through to the third section where you can
specify dates. -- HTH Bob "Keoni2008" wrote in message ... I have about 2000 rows (x4 in columns) of dates in 2 formats and they are "0/00/00 and 00/00/0000". How can I quick fix this problem into just one format for all like this way "00/00/00"? I tried using the formula and it did not help at all and the other way was for me to use "format cells, category-date, type-00/00/00". Then, after I have to manually go into each cell and double click it and that the only way it will format it. Please help there must be an easier way to fix this problem.
|
|
#3
May 28th, 2010, 11:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Dates in excel
If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "Keoni2008" wrote in message ... I have about 2000 rows (x4 in columns) of dates in 2 formats and they are "0/00/00 and 00/00/0000". How can I quick fix this problem into just one format for all like this way "00/00/00"? I tried using the formula and it did not help at all and the other way was for me to use "format cells, category-date, type-00/00/00”. Then, after I have to manually go into each cell and double click it and that the only way it will format it. Please help there must be an easier way to fix this problem.
|
|
#4
May 29th, 2010, 12:53 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Dates in excel
Keoni,
Once you format one of the cells and if you are happy, use format painter for the rest. I should work. Tamer Paksoy "Keoni2008" wrote: I have about 2000 rows (x4 in columns) of dates in 2 formats and they are "0/00/00 and 00/00/0000". How can I quick fix this problem into just one format for all like this way "00/00/00"? I tried using the formula and it did not help at all and the other way was for me to use "format cells, category-date, type-00/00/00”. Then, after I have to manually go into each cell and double click it and that the only way it will format it. Please help there must be an easier way to fix this problem.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
