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
|