View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
·!¦[··ï¡?¡ï·»Gen°Digger«·ï¡?¡ï··]¦!· ·!¦[··ï¡?¡ï·»Gen°Digger«·ï¡?¡ï··]¦!· is offline
external usenet poster
 
Posts: 2
Default Midnight will not display in cell

Ok... jeepers.. another problem... ggrrrr

When I enter the time of midnight using military format 24:00, or using 0:00, it does not display in the cell, but it does correctly in the formula bar. Is there a way I can correct this please? I have the 1904 in "Options" selected, but it doesn't seem to be helping... ideas?

Thank you... sorry...

Terrae