Thread: i want default as Zero in date format cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anitha Anitha is offline
external usenet poster
  
Posts: 4
Default 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
Reply With QuoteReply With Quote