| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format will not change in Excel
I have a file with dates in one column, trying to change the date format but
the format command does not work. The values do not appear to be stored as text, but will not change to any other format (general, number, currency, etc) unless each cell is selected and edited (i.e. double click on the cell then leave the cell) then the format changes. Too many cells to do this manually. It only occurs in one column, all others change with the format command. Tried pasting the values to another pre-formatted cell, no luck. Anyone know why this happens? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change date yyyymmdd to a Excel-supported date format? | Excel Worksheet Functions | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| How do I change GLOBAL date format in excel? | Excel Discussion (Misc queries) | |||
| Excel, want to change date format from us to uk, for old data. | Excel Discussion (Misc queries) | |||
| How change the date format in the excel footer to dd mmm yy? | Excel Discussion (Misc queries) | |||
Threaded Mode
