You are here

Openoffice.org Calc Help Please

7 posts / 0 new
Last post
Bigtom71291
Offline
Last seen: 12 years 9 months ago
Joined: 2009-01-06 10:13
Openoffice.org Calc Help Please

Hi i need help

okay so when i enter things like 3-5, 6-8 etc... it turns it to a date like 3/5/09 or 6/8/09 how do i stop it from doing this?

thanks in advance Smile

John T. Haller
John T. Haller's picture
Offline
Last seen: 5 hours 13 min ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
=2-5

if you want to enter a formula, you need to enter and equal sign first. OpenOffice.org has a pretty good manual on it somewhere that should help Smile

Sometimes, the impossible can become possible, if you're awesome!

Bigtom71291
Offline
Last seen: 12 years 9 months ago
Joined: 2009-01-06 10:13
Thanks john for the info but

Thanks john for the info but i am not trying to do math i am making a workout schedule

EX. this is a basic out line what i am trying to do

bench press

           weight reps rest(between reps) sets
Light      135    10   1 min                3 

medium     185    6-8  3 min                2

heavy      225    3-5  5 min                2
 

sorry i should of explain it better

Sig Coming Soon!

John T. Haller
John T. Haller's picture
Offline
Last seen: 5 hours 13 min ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
Ah

Use a single quote to indicate a text field. So you'd type '6-8

Sometimes, the impossible can become possible, if you're awesome!

Bigtom71291
Offline
Last seen: 12 years 9 months ago
Joined: 2009-01-06 10:13
hm but wouldn't people think

hm but wouldn't people think that means inches or something :/ or i guess i can put 6 or 8 but if i do that i still kind of want to know how to turn that off

Sig Coming Soon!

John T. Haller
John T. Haller's picture
Offline
Last seen: 5 hours 13 min ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
It disappears

The whole point is that it disappears. It indicates to OO.o that "THIS IS A TEXT FIELD, DON'T MESS WITH IT"

Spreadsheets have used it for years and years now. It's universal.

Sometimes, the impossible can become possible, if you're awesome!

Bigtom71291
Offline
Last seen: 12 years 9 months ago
Joined: 2009-01-06 10:13
oh! Thanks man

oh! Thanks man yea as you can probably tell i am new at this Blum

Sig Coming Soon!

Log in or register to post comments