Would pre-formatting the cell as text do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"pogo" wrote in message
...
I have cells a1 and a2 that I use to figure out various sums, differences,
and other aspects of times(military). The person using the form enters a
time
in a1( a start time) then they enter a stop time in a2. they use miltary
time
to enter the times. When the person enters 00:00 in cell a1( simulating 12
in the morning) and just say 15:00 in cell a2(stop time simulating 3pm),
the
calculations still happen as excel knows what was typed in, but cell a1
remains blank. cell a2 shows the numbers 15:00. for some reason when
entering
military time and you use 00:00, excel blanks out the cell that you typed
00:00 into. If I entered 00:01, then those numbers would show in cell a1,
but
then the form wouldnt do its purpose. I need cell a1 to show that 00:00
was
entered and actually show the numeral"00:00". this allows outsiders and
insiders to know that somthing was started at 12am. The form also needs to
remain using military time. I tried but couldnt figure it out.there is
always
someone smarter out there. Please help?
Thanks

"Fred Smith" wrote:

Well, that's trickier.

It begs the question, why do you have zeros in empty cells? Why not have
blanks?
That, by far, would be the easiest solution.

If that's not possible for whatever reason, post back, and we'll look for
another solution.

--
Regards,
Fred


"pogo" wrote in message
...
I am sorry I meant to say that I only want the zeros to appaer in only
one
column, if I check the zero box in options it clutters up the form by
filling
in zero's in all of the empty cells. How would I have the zeros fill
into
only specic cells on the form and not any others? sorry I was so vague
earlier.

"Fred Smith" wrote:

Go to ToolsOptionsView and check Zero values.

--
Regards,
Fred


"pogo" wrote in message
...
whenever I place 00:00(12am)in a cell, excel still calculates the
cell
information as 00:00 but the cell remains blank, as if nothing is in
it.
how
do I make excel show "00:00" in that cell . it only happens when I
use
00:00
in my form.
Thanks in advance