Disapprearing Zero

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

Guest

Hello, If anyone can help. I am using a excel for filling out time sheets
where I work and when I enter the start time of my job excel is kicking out a
number. for example I need to input this 0830 when I hit enter or move to
next cell it turns into this 830. Problem is that it must be a 4 digit entry
for my employer. Is there a way to stop excel from taking out the 0.. by the
way it is only zero that is kicking out no other numbers.

Thanks for the help,
 
If it *must* be a true XL number, custom format to:
0000

If text entries are acceptable,
*pre*format the cell(s) as Text,
OR
precede the data entry with an apostrophe ( ' ).
 
It is preferable to enter the time using Excel's standard time format of
08:30, not 0830. Then you can easily do arithmetic on the time values.
 
Thanks for the help..

The apostrophe worked perfect. The Colon didn't work.

I appreciate the help.

A. J. M.
 
I'm fascinated to hear that the colon didn't work. Tell us more? What time
format did you use in the cells?
 
David, I translated the OP as meaning the data was to be imported into the
company payroll app.
 
Back
Top