EXCEL QUES.
| Posted By | Message |
|---|---|
|
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. |
|
Posted 3/23/07 11:58 AM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
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
|
|
|
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 |
|
Posted 3/23/07 12:00 PM
|
|
|
Re: EXCEL QUES. That is the minus sign.... |
|
Posted 3/23/07 12:01 PM
|
|
|
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
|
|
|
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
|
|
|
Re: EXCEL QUES. not sure-- it's coming up as "#VALUE!" |
|
Posted 3/23/07 12:04 PM
|
|
|
Re: EXCEL QUES. RIGHT CLICK ON THE CELL AND CHANGE THE FORMAT TO "NUMBER" OR "CURRENCY" SEE IF THAT WORKS |
|
Posted 3/23/07 12:05 PM
|
|
|
Re: EXCEL QUES. OK-- i JUSt added another line since it's silly to waste my time on figuring it out-- now it works. |
|
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 ™ |






