simple format cells as Number with custom 0000 format.
This will ensure that 0600 appears as 0600 and not 600

Steve


On Fri, 01 Dec 2006 10:13:00 -0000, SpencerMC
wrote:

I have a column in my worksheet that users enter their start time in 24hr
clock (military time) e.g. 1830 or 0700

If I format the column using any of the time formats, I get various
results
since Excel treats the entry as a value and converts this into a time
(never
really understood this).

However, I don't need to do any calucalution with these times; it's
effectively just there as text. So when users enter 1830 it stays as
1830. So
far so good. However if they enter something with a preceeding 0, such as
0630, Excel removes the first zero and it becomes 630. In a list of 24hr
times this looks odd and will confuse people.

So any suggestions? I just want users to enter 24hr times and for them
to be
formated as such (as text or otherwise!) Cheers.