Microsoft Invoice Template and Unfriendly Macros

B

Bill

I'm using the Invoice template that comes with Excel 2000. I'm trying to
enter a negative number (to represent a discount) and I keep getting a popup
called "Unit Price" that says "You must enter a number into this cell". I've
tried disabling macros, reformatting the cell - nothing works.

Is anyone familiar enough with this template to tell me how to allow both
positive & negative numbers in cells?

ba
 
A

Andy Brown

"Bill",

In my version, K18:K34 have data validation. You can remove or adjust this
via Data >> Validation, seems to still work OK.

HTH,
Andy
 

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

Negative numbers in Excel Invoice 4
Entering a negative value into the invoice template 0
help! 0
Auto Assigning Number to Excel Invoice 5
Cells won't automatically update --- urgent! 3
Referring to columns from within a macro 4
"You must enter a number in this cell" - ??? 3
Creating an invoice with a lookup list 6

Top