| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing date formatted as general number into date format
Hi -
I have a rather large dataset that arrived with all the dates formatted as general numbers which I can't seem to convert to a date format that is recognized by either excel or access 07 - I've tried converting to regular number then to text as well as converting to text and then to date but I can't seem to make it work. The dates are also represented in yyyymmdd format - ie, 20070105 which doesn't line up with the typical american date format. Any suggestions? Any help would be appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the date format on the date table in a chart | Charts and Charting in Excel | |||
| column formatted to general - cells keep changing to date? | New Users to Excel | |||
| general date to date format | Excel Discussion (Misc queries) | |||
| Date format for general formatting | Excel Discussion (Misc queries) | |||
| number keep being formatted as date | New Users to Excel | |||
Threaded Mode
