EXCEL QUES.

Posted By Message

randella
Love my little man

Member since 8/05

16290 total posts

Name:
Randi

EXCEL QUES.

How do you do a minus sign when creating a formula? I am using the dash next to the +/= key and it keeps coming up invalid.Chat Icon

Posted 3/23/07 11:58 AM
 
Long Island Weddings
Long Island's Largest Bridal Resource

MsG
Should be working

Member since 5/05

2824 total posts

Name:
G

Re: EXCEL QUES.

is caps lock on? did you use an = sign in the formula? I use the - that you are talking about, so I'm not sure what it could be.

Posted 3/23/07 12:00 PM
 

nixy
LIF Adult

Member since 9/06

1575 total posts

Name:
K

Re: EXCEL QUES.

do you have the #'s on the right side of your keayboard? there is a minus on the top right corner. try that

or are you pressing shift by mistake?

Posted 3/23/07 12:00 PM
 

missus-hbradio
Twin mommy

Member since 5/05

15857 total posts

Name:

Re: EXCEL QUES.

That is the minus sign.... Chat Icon

Posted 3/23/07 12:01 PM
 

randella
Love my little man

Member since 8/05

16290 total posts

Name:
Randi

Re: EXCEL QUES.

Posted by nixy

do you have the #'s on the right side of your keayboard? there is a minus on the top right corner. try that

or are you pressing shift by mistake?



nope-- on a lap top-- this is probably why I have not encountered this problem before.

Caps lock is not on-- otherwise the symbol would come up as an underscore.

Posted 3/23/07 12:01 PM
 

nixy
LIF Adult

Member since 9/06

1575 total posts

Name:
K

Re: EXCEL QUES.

Posted by randella

Posted by nixy

do you have the #'s on the right side of your keayboard? there is a minus on the top right corner. try that

or are you pressing shift by mistake?



nope-- on a lap top-- this is probably why I have not encountered this problem before.

Caps lock is not on-- otherwise the symbol would come up as an underscore.



hmmmm......

are you shore it is the minus sign that is making it invalid?

Posted 3/23/07 12:03 PM
 

randella
Love my little man

Member since 8/05

16290 total posts

Name:
Randi

Re: EXCEL QUES.

not sure-- it's coming up as "#VALUE!"

hate thatChat Icon

Posted 3/23/07 12:04 PM
 

MrsPorkChop
Twinning!!

Member since 5/05

9941 total posts

Name:
Missy

Re: EXCEL QUES.

RIGHT CLICK ON THE CELL AND CHANGE THE FORMAT TO "NUMBER" OR "CURRENCY" SEE IF THAT WORKS

YOU CAN ALSO RIGHT CLICK ON A CELL THAT IS COOPERATING, COPY IT, THEN PASTE IT INTO THE NEW CELL

Posted 3/23/07 12:05 PM
 

randella
Love my little man

Member since 8/05

16290 total posts

Name:
Randi

Re: EXCEL QUES.

OK-- i JUSt added another line since it's silly to waste my time on figuring it out-- now it works.

Thanks girls!

Posted 3/23/07 12:05 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
Is it true? ques. on fence BobBsWife 3/14/07 7 Home
ques. if you are having a planned C-Section, XPOST/crashing your board Kerie-is-so-very 11/27/06 10 Pregnancy
Anyone ever use Lending Tree? Plus credit inq ques BabyAvocado 5/8/06 5 Families Helping Families ™
Ques. for Business owners MRSE 3/3/06 11 Families Helping Families ™
Ques,-UPS delivery Smileyd17 2/10/06 4 Families Helping Families ™