mulberry13
Board Regular
- Joined
- Nov 23, 2005
- Messages
- 204
When I put in a zip code (15666-5021) how do I force Excel to save the zipcode in this format?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Zipcode issue
- Thread starter mulberry13
- Start date
Akashwani
Well-known Member
- Joined
- Mar 14, 2009
- Messages
- 2,911
Hi,
Do you require the Zipcode to be saved as a number rather text?
You can format your cell(s) by doing this.....
Highlight your cell(s)
Right Click
Click Format Cells
Click Custom
In the white box underneath Type put this....
0000"-"0000
Click Ok.
You can now type your number in like this....
156665021 and Excel will format it to 15666-5021.
I hope that works for you.
Good luck.
Ak
Do you require the Zipcode to be saved as a number rather text?
You can format your cell(s) by doing this.....
Highlight your cell(s)
Right Click
Click Format Cells
Click Custom
In the white box underneath Type put this....
0000"-"0000
Click Ok.
You can now type your number in like this....
156665021 and Excel will format it to 15666-5021.
I hope that works for you.
Good luck.
Ak
Upvote
0
Similar threads
- Question
