how do i prevent excel from automatically changing 0300 to 300?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am trying to type military time, but when i enter 0000, excel changes it to
0. when i type 0300, excel changes it to 300. how can i make excel accept
what i type as is?
 
Use a custom number format of 0000. Note, however, that the true underlying
value of the cell will still be 300 even though it is *displayed* as 0300.

Biff
 
Back
Top