View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pogo Pogo is offline
external usenet poster
 
Posts: 17
Default 24 hour time format help with 00:00 calculation

whenever I place 00:00(12am)in a cell, excel still calculates the cell
information as 00:00 but the cell remains blank, as if nothing is in it. how
do I make excel show "00:00" in that cell . it only happens when I use 00:00
in my form.
Thanks in advance