I want macro in Excel to format cells as Zipcode in the format #####-####

Hello

You could have got this yourself by recording a macro :-
;)

Code:

---

ActiveSheet.Range("A1").NumberFormat = "#####-#####"

---

Thanks Brian... I used your post also...

Tom :afrog: :afrog: :afrog: :afrog: