View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
J Sedoff[_2_] J Sedoff[_2_] is offline
external usenet poster
 
Posts: 26
Default Printing Leading Zeroes in Excel

Are the cells formatted correctly?

select the cells in question, go to the "Format" menu, select "Cells" (or
press Ctrl+1), click on the "Number" tab, then choose the "Zip Code + 4" (not
just "Zip Code") type under the "Special" category and click "OK".

Hope this helps, Jim