| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative numbers in Excel Invoice
I am trying to add in a discount in an invoice but I keep getting the message
"You must enter a number into this cell" when I type in the negative sign. I have also tried to do a formula (SUM(1400-1846.25) and it still won't accept the negative. The sheet is unprotected. How do I get it to accept negative numbers? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative numbers in Excel Invoice
Is this a wb you made? Or is it based off a template you downloaded?
-- John C "Karen" wrote: I am trying to add in a discount in an invoice but I keep getting the message "You must enter a number into this cell" when I type in the negative sign. I have also tried to do a formula (SUM(1400-1846.25) and it still won't accept the negative. The sheet is unprotected. How do I get it to accept negative numbers? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative numbers in Excel Invoice
This was a template that was installed when I got the software. It's Excel
2000. "John C" wrote: Is this a wb you made? Or is it based off a template you downloaded? -- John C "Karen" wrote: I am trying to add in a discount in an invoice but I keep getting the message "You must enter a number into this cell" when I type in the negative sign. I have also tried to do a formula (SUM(1400-1846.25) and it still won't accept the negative. The sheet is unprotected. How do I get it to accept negative numbers? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative numbers in Excel Invoice
It sounds like the developer of that invoice may have data|validation set for
that cell. I'd look there first to see if that's turned on. I have no idea if removing it will break the rest of the invoice, though. Karen wrote: I am trying to add in a discount in an invoice but I keep getting the message "You must enter a number into this cell" when I type in the negative sign. I have also tried to do a formula (SUM(1400-1846.25) and it still won't accept the negative. The sheet is unprotected. How do I get it to accept negative numbers? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative numbers in Excel Invoice
The Data -- Validation thing was exactly it. Thanks!
"Dave Peterson" wrote: It sounds like the developer of that invoice may have data|validation set for that cell. I'd look there first to see if that's turned on. I have no idea if removing it will break the rest of the invoice, though. Karen wrote: I am trying to add in a discount in an invoice but I keep getting the message "You must enter a number into this cell" when I type in the negative sign. I have also tried to do a formula (SUM(1400-1846.25) and it still won't accept the negative. The sheet is unprotected. How do I get it to accept negative numbers? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| Excel - invoice numbers | Excel Worksheet Functions | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| How to switch negative numbers to positive numbers in Excel ? | Excel Worksheet Functions | |||
| Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
Linear Mode
