View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

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?