View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mark Ivey Mark Ivey is offline
external usenet poster
 
Posts: 120
Default Excell formatting

The only fix I have found for keeping a leading "0" is to change the cell
format to TEXT.


Select the affected cells, then CTRL + 1, then select TEXT as the number
type.


"Jeffery" wrote in message
...
Hi all. I'm new to this, firgured someone here might be able to answer my
question. I have Office 2007. I'm trying to write a report for my
science
class and have to enter the time in mililtary format. However when ever I
enter the time as 0645, it automatically changes it to 645. This is not
correct. I have tried just about everything I can find - but it won't
stop
this auto converting... anyone know how to make it display what I type in
and
not change it to how it wants it to read?
--
Jeffery