| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want default as Zero in date format cell
if i fill date in 1 cell (cell is in date Format of mm-mon-yyyy) then i get
date but if i live it blank it gives 00-jan-00. i want it to display as zero can u please help me |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text and date format in a cell | Excel Discussion (Misc queries) | |||
| Date format does not appear in cell | Excel Discussion (Misc queries) | |||
| How I convert date formatt of dd/mm/yy to mm/yy (not cell format) | Excel Discussion (Misc queries) | |||
| How to change default cell format to "Text" | Excel Discussion (Misc queries) | |||
| date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
Threaded Mode
