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 > [email protected] > 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: [email protected] -- 73 de Joe Miller, KJ8O, Troy, MI -- Grid EN82 -- ------ WOW! Homepage (http://www.wowway.com) ------ _______________________________________________ IRCA mailing list [email protected] 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: [email protected]
