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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want default as Zero in date format cell
If the cell is truly blank, it will display as blank.
If it has a value of 0, it will display as you suggest. In this case it may be possible to create a custom format to display as 0, but you can easily make it appear as blank. Go to ToolsOptionsView tab and deselect the Zero values checkbox. -- Ian -- "Anitha" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want default as Zero in date format cell
try to format cell
custom type: dd-mmm-yy;;General "Anitha" ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
i want default as Zero in date format cell
Anitha
Under FormatCellsCustom enter mm-mon-yyyy;;0 -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "Anitha" wrote in message ... 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 |
Reply |
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) |