View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default 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?