You need a custom format. Type "hh:mm" in the text window after you've clicked on "custom" to create a new format that forces 2 hours digits and 2 minutes digits.
Chuck -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Russ Edmunds Sent: Sunday, September 14, 2008 3:40 PM To: IRCA List Subject: Re: [IRCA] 24 hour clock in Excel Format / Cells / Number / Custom will get you 00500...( so will the same sequence but ending using "Zip Code" ) But so far I haven't figured that out either, and I use Excel daily. Russ Edmunds Blue Bell, PA ( 360' ASL ) [15 mi NNW of Philadelphia] 40:08:45N; 75:16:04W, Grid FN20id <[EMAIL PROTECTED]> FM: Yamaha T-80 & Onkyo T-450RDS w/ APS9B @15' AM: Modified Sony ICF 2010 barefoot --- On Sun, 9/14/08, Bob Coomler <[EMAIL PROTECTED]> wrote: > From: Bob Coomler <[EMAIL PROTECTED]> > Subject: [IRCA] 24 hour clock in Excel > To: [email protected] > Date: Sunday, September 14, 2008, 6:14 PM > 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] _______________________________________________ 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] _______________________________________________ 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]
