View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DazzaData DazzaData is offline
external usenet poster
 
Posts: 49
Default how do i keep zip code zeros from disappearing

format - custom 00000 should work
cheers


"debh" wrote:

Excel 2003 Have tried formatting the column/cells in special format for
zips - no go
Tried text format, them apostrophe before zip - did n't work

Help