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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ajm583" wrote in message
...
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,

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.
--
David Biddulph

"ajm583" wrote in message
...
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,

Thanks for the help..

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

I appreciate the help.

A. J. M.

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"ajm583" wrote in message
...
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 Biddulph

"ajm583" wrote in message
...
Thanks for the help..

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

I appreciate the help.

A. J. M.

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
I'm fascinated to hear that the colon didn't work. Tell us more? What
time format did you use in the cells?
--
David Biddulph

"ajm583" wrote in message
...
Thanks for the help..

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

I appreciate the help.

A. J. M.