Open Office spreadsheet

Avatar

Please consider registering
Guest

Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_topic_old
Open Office spreadsheet
Avatar
cricket
Member
Forum Posts: 11
Member Since:
March 10, 2010
sp_UserOfflineSmall Offline
1
September 26, 2010 - 11:23 am
sp_Permalink sp_Print

I don't use MS Excel but maybe you can help me. I have my Christmas Card list set up in spreadsheet form and in the column for zip code I have a zip code that starts with 0 and I can't get it to show up it leaves the 0 off. Do you have any suggestions as to how I can fix this. Thanks

Avatar
David Hartsock
Admin
Forum Posts: 1105
Member Since:
August 7, 2011
sp_UserOfflineSmall Offline
2
September 26, 2010 - 7:32 pm
sp_Permalink sp_Print

What program are you using?

Avatar
Carol Bratt
Mod
Forum Posts: 66
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
3
September 26, 2010 - 8:46 pm
sp_Permalink sp_Print

In OpenOffice Calc, click on View.

Under Display check Zero Values.

If this does not resolve your issue, please post back here and we will take another crack at it!

Avatar
cricket
Member
Forum Posts: 11
Member Since:
March 10, 2010
sp_UserOfflineSmall Offline
4
September 27, 2010 - 8:19 am
sp_Permalink sp_Print

Dave I am using Open Office 3.2.1

Carol when I click on View I can't find a Display or a Zero Values.

Avatar
David Hartsock
Admin
Forum Posts: 1105
Member Since:
August 7, 2011
sp_UserOfflineSmall Offline
5
September 27, 2010 - 6:35 pm
sp_Permalink sp_Print

Cricket,

I don't use Open Office, but I assume OO works similarly to MS Office and take a stab until Carol gets back...

If you right click on a problem cell look for a Format command in the menu. You can usually change the format of a cell to things like text, general, date, etc. These tell the software how to handle the information in that cell and each one will change the way the data displays and interacts with the other data. I would try different options to see which option gets the result you want. I imagine Text or General would work (it is a number, but there are no calculations to be made).

If you find the one that corrects the problem you can click on the row or column label and do the exact same for the entire row/column to fix all of them.

Avatar
Carol Bratt
Mod
Forum Posts: 66
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
6
September 27, 2010 - 7:40 pm
sp_Permalink sp_Print

Cricket,

I am not using the latest version of Calc but it should not be that different.

[b:1i0itgpo]Applying Formatting Using the Format Cells Window[/b:1i0itgpo]

Select the cells you would like to format.

Right-click on one of the selected cells and select Format Cells.

In the Format Cells dialog that appears, select the Numbers tab if it is not on top.

In the Category list, select the type of data you are dealing with and inthe Format list, select specifically what yu want it to look like.

[b:1i0itgpo]Specify the number of leading zeroes, if any, for the number. If the value for th eleading zeroes does not stick, try formating the number as Text or General if appropriate. This is the approach you will need to use for postal codes.[/b:1i0itgpo]

Apply the Category of Text and the Format of @ if you want just the cell to accept normal text with no number formatting.

I hope this is helpful to you.

Avatar
cricket
Member
Forum Posts: 11
Member Since:
March 10, 2010
sp_UserOfflineSmall Offline
7
September 28, 2010 - 8:57 am
sp_Permalink sp_Print

Thank you. Doing the text format with @ did the trick for the Zip Code cells. Since I only print my Christmas Labels once a year it takes me forever to remember how to do it. Have never had an formal training in using Word or Excel and learning on my own at an older age takes time. But I am so glad I didn't give up and stuck with it. Wouldn't take anything for my computer.

Avatar
Carol Bratt
Mod
Forum Posts: 66
Member Since:
August 11, 2011
sp_UserOfflineSmall Offline
8
September 28, 2010 - 11:13 am
sp_Permalink sp_Print

Glad I was able to help you Cricket!

Forum Timezone: America/Indiana/Indianapolis

Most Users Ever Online: 188

Currently Online:
15 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Member Stats:

Guest Posters: 10

Members: 1273

Moderators: 3

Admins: 4

Forum Stats:

Groups: 8

Forums: 19

Topics: 1538

Posts: 11824

Administrators: Jim Hillier, Richard Pedersen, David Hartsock, Marc Thomas

Moderators: Judy Novotny, Jason Shuffield, Mail Poet