Select the cells to which you want to apply a number format.
Go to Format > Cells….
Select the Numbers tab in the Category section, and choose the format you desire.
You can define a "user-defined" format too, by choosing the User-defined tab in the Category section. Enter the format you desire, click on the Add button, the green little button with a check mark, and click OK.
For a zip code, you must format the numbers as text. To do that, enter an apostrophe ' before the code: '01234.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum