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
|