Remember Me?

#1
February 19th 05, 06:19 PM
 PAtty Posts: n/a
How to show a leading 0 in a cell.

I can't remember the tip of how to show a leading zero in a cell. For
instance a zip code of 01234. I know there's a key you can hit and the zero
will show and not disappear when you go to the next cell.

Anyone know it?

#2
February 19th 05, 06:46 PM
 Don Guillett Posts: n/a

use text or ' before puttin in or format as 00000000000 (as many as you want
to show)

--
Don Guillett
SalesAid Software

"PAtty" wrote in message
...
I can't remember the tip of how to show a leading zero in a cell. For
instance a zip code of 01234. I know there's a key you can hit and the

zero
will show and not disappear when you go to the next cell.

Anyone know it?

#3
February 20th 05, 01:03 AM
 Gord Dibben Posts: n/a

Patty

Precede the 01234 with an apostrophe which won't show in the cell but will
retain the 0.

Note, this will be a text value, not a real number for the purposes of
arithmetical calculations.

If you need 01234 for show and 1234 as a number, custon format to 00000.

Gord Dibben Excel MVP

On Sat, 19 Feb 2005 10:19:01 -0800, "PAtty"
wrote:

I can't remember the tip of how to show a leading zero in a cell. For
instance a zip code of 01234. I know there's a key you can hit and the zero
will show and not disappear when you go to the next cell.

Anyone know it?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mark Excel Worksheet Functions 3 March 21st 05 07:53 AM J-Philippe Excel Worksheet Functions 4 January 15th 05 08:41 PM Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM o0o0o0o Excel Worksheet Functions 6 November 19th 04 03:13 PM ria Excel Worksheet Functions 4 November 6th 04 04:38 AM

All times are GMT +1. The time now is 01:47 AM.