| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format dates and not Zeros
I need some code to:
I have a column (F) that contains dates and zeros. How can I change the format to date (YYYYMMDD) and leave the zeros as zeros and not get the 19000100 date? 0 6/7/2004 7/19/2004 0 0 0 0 0 1/31/2005 3/14/2005 9/13/2004 10/18/2004 1/31/2005 7/12/2004 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replacing zeros with blanks but leaving dates alone | Excel Worksheet Functions | |||
| Sorting Dates when there are zeros in the month and/or day | Excel Discussion (Misc queries) | |||
| Format zeros | Excel Discussion (Misc queries) | |||
| leading zeros fall off in csv format. | Excel Discussion (Misc queries) | |||
| save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Threaded Mode
