View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Midnight will not display in cell

Do you have Custom formatting or conditional formatting set to hide 0
values? How about the Tools/Options/View Zero values checkbox checked?

In article ,
·!¦[··ï¡?¡ï·»Gen°Digger«·ï¡?¡ï··]¦!· wrote:

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...