Disapprearing Zero

A

ajm583

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,
 
R

Ragdyer

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 ( ' ).
 
D

David Biddulph

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.
 
A

ajm583

Thanks for the help..

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

I appreciate the help.

A. J. M.
 
D

David Biddulph

I'm fascinated to hear that the colon didn't work. Tell us more? What time
format did you use in the cells?
 
R

RagDyer

David, I translated the OP as meaning the data was to be imported into the
company payroll app.
 
Top