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