| Home |
| Search |
| Today's Posts |
|
#1
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting of dates in two cells using Excel 2007 | Excel Worksheet Functions | |||
| Excel formatting dates | Excel Worksheet Functions | |||
| Formatting Dates in Excel | Excel Discussion (Misc queries) | |||
| Excel Conditional Formatting - Two Dates Comparison | Excel Discussion (Misc queries) | |||
| Re-formatting of dates from Excel to CSV | Excel Discussion (Misc queries) | |||
Threaded Mode
