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

R

rutherford

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?
 
T

T. Valko

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
 
Top