Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Formatting zip codes in neo calc
Formatting zip codes in neo calc
 
   NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
assistant3
Agent


Joined: Oct 20, 2006
Posts: 12

PostPosted: Mon Oct 22, 2007 12:14 pm    Post subject: Formatting zip codes in neo calc

Hello everyone,

would any of you be able to point me in the direction of documentation on number formatting and/or zip code formatting formulas in NeoOffice Calc.....

thanks so much

-Noah
Back to top
jgd
Agent Smith


Joined: Feb 27, 2005
Posts: 1531
Location: France

PostPosted: Mon Oct 22, 2007 12:41 pm    Post subject:

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.

Jacqueline
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
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

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.