View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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?