8/28/15
Original Poster
Kevin HershLeading zero for zip code east cost YES, I figured it out. 00000
No thanks to it not being a standard format google. I stitches together everyone's ideas and this is what I came up with, a solution:
1. Select the entire column so all cells are formatted.
2. Go to 123 format menu item
3. Select more formats/Custom number format
4. Create a new format that contains 5 zeros 00000
5. Pain is over, get to work, have fun.
Community content may not be verified or up-to-date. Learn more.
This question is locked and replying has been disabled. Still have questions? Ask the Help Community.
Badges
Some community members might have badges that indicate their identity or level of participation in a community.
Community content may not be verified or up-to-date. Learn more.
Levels
Member levels indicate a user's level of participation in a forum. The greater the participation, the higher the level. Everyone starts at level 1 and can rise to level 10. These activities can increase your level in a forum:
- Post an answer.
- Having your answer selected as the best answer.
- Having your post rated as helpful.
- Vote up a post.
- Correctly mark a topic or post as abuse.
Having a post marked and removed as abuse will slow a user's advance in levels.
View profile in forum?
To view this member's profile, you need to leave the current Help page.
Report abuse in forum?
This comment originated in the Google Product Forum. To report abuse, you need to leave the current Help page.
Reply in forum?
This comment originated in the Google Product Forum. To reply, you need to leave the current Help page.