View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rutherford rutherford is offline
external usenet poster
 
Posts: 1
Default how do i prevent excel from automatically changing 0300 to 300?

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?