Hi Bob,
Since this radio related, I'm hoping I'm not "off topic". One thing you
can
do is for your column with the times, highlight the entire column (using
the
grey box at the top of the column). Then click, in the following order:
Format, Cells, Number, Text and OK. Now go to that column, type in 'zero
zero zero one" and you will see that the leading zeroes don't disappear.
I've been doing it that way for several years and I've found it workss
very
well, even if you want to do some sorting later on.
Hope this helps.
73 de Joe, KJ8O
On Sun, 14 Sep 2008 15:14:20 -0700 (PDT), Bob Coomler wrote
This probably should be simple, but I'm lost. I'm setting up Excel
spreadsheets for my primary logging program (not at all happy with
the pre-packaged ones). How can I get it to show a leading zero
when using the 24 hour clock: i.e. 0500? No matter what I seem to
do, it will show as 5:00 or 500. There has gotta be a way! Thanks
for any suggestions.
Bob Coomler
Cloverdale, CA
_______________________________________________
IRCA mailing list
IRCA@xxxxxxxxxxxxxxxx
http://montreal.kotalampi.com/mailman/listinfo/irca
Opinions expressed in messages on this mailing list are those of the
original contributors and do not necessarily reflect the opinion of
the IRCA, its editors, publishing staff, or officers
For more information: http://www.ircaonline.org
To Post a message: irca@xxxxxxxxxxxxxxxx
-- 73 de Joe Miller, KJ8O, Troy, MI -- Grid EN82 --
------ WOW! Homepage (http://www.wowway.com) ------
_______________________________________________
IRCA mailing list
IRCA@xxxxxxxxxxxxxxxx
http://montreal.kotalampi.com/mailman/listinfo/irca
Opinions expressed in messages on this mailing list are those of the
original contributors and do not necessarily reflect the opinion of the
IRCA, its editors, publishing staff, or officers
For more information: http://www.ircaonline.org
To Post a message: irca@xxxxxxxxxxxxxxxx