| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Format when incoming date can be 0
I have a date fiels yyyymmdd which can have a value of 0 or a valid date in
recent past. Excel displays the 0 date as 01/01/1900 and the non zero dates as expected. Cant figure this out , any help would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format the "date" button for a header | Excel Discussion (Misc queries) | |||
| Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| How to format a date to a different format | Excel Discussion (Misc queries) | |||
| Date Format Question | Excel Discussion (Misc queries) | |||
Threaded Mode
