There are already values in the form of ZipCode, but those are not in the format of "#####-####", so i want macro to replace those format with standard format
Thanku
There are already values in the form of ZipCode, but those are not in the format of "#####-####", so i want macro to replace those format with standard format
Thanku
Start a macro record
Highlight all the cells
Right click>Format Cells (general tab)
Select custom format
Enter the format
Click ok
Stop the recording
Look at the code...