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 
You are here
Openoffice.org Calc Help Please
March 9, 2009 - 12:08am
#1
Openoffice.org Calc Help Please
March 9, 2009 - 12:14am
#2
=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
March 9, 2009 - 12:24am
#3
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
March 9, 2009 - 12:26am
#4
Ah
Use a single quote to indicate a text field. So you'd type '6-8
March 9, 2009 - 12:32am
#5
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
March 9, 2009 - 12:38am
#6
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.
March 9, 2009 - 12:48am
#7
oh! Thanks man
oh! Thanks man yea as you can probably tell i am new at this 
Visit the Community page
Join our forums