Thread: Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lamar Lamar is offline
external usenet poster
 
Posts: 3
Default Format


I have a spreadsheet with a list of Zip Codes. The Zip Codes are formatted
as
"#####-####". So it looks like 98507-9046 but was entered as 985079046.

I want the Zip Codes to be stored as 98507-9046 instead of 985079046. How
can I do this for over 1000 entries instead of doing it manually one by one?

thanks, Lamar