Negative numbers in Excel Invoice

K

Karen

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
Negative value to positive 13
if cell is blank 8
Negative Numbers 8
Separting negative numbers from letters in cells 1
IF Statement accepting only positive values 1
Excel - Adding positive or negative numbers in a column 5
Microsoft Query is changing a negative number into a date 1

Top