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