| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thanks for the help
"JE McGimpsey" wrote: Your dates were entered as Text, which isn't subject to Number Formats. You can coerce them back to XL dates by copying a blank cell, selecting your dates and choosing Edit/Paste Special, selecting the Values and Add radio buttons. Change the format to your desired one. In article , "RickSenn" wrote: After selecting a column and changing format to custom date yyyymmdd. The changes do not take place. Double Clicking in the individual cells afterwards bring up the desired results. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Date Format - users should be able to override it automatic. | Excel Discussion (Misc queries) | |||
| Format Cells - Date options | Excel Discussion (Misc queries) | |||
| Date format | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
| Date format | Excel Discussion (Misc queries) | |||
Threaded Mode
