3
389Shell
When I try it just tells me I must enter a number. I am running office 2003.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CyberTaz
You should be able to type something such as -249.95 with no problem. Do not
type any other characters or spaces. If the cell will not accept the entry it
probably has a Validation Rule applied which prevents the entry of negative
values. My guess is that someone else created the workbook file and they may
be the one who needs to make the change if necessary.
HTH |:>)
type any other characters or spaces. If the cell will not accept the entry it
probably has a Validation Rule applied which prevents the entry of negative
values. My guess is that someone else created the workbook file and they may
be the one who needs to make the change if necessary.
HTH |:>)
3
389Shell
I created the workbook and I have not created any such rule for it. I have
managed to now put in a negative amount by right clicking and formatting the
cell but it still will not add this in the total column.
managed to now put in a negative amount by right clicking and formatting the
cell but it still will not add this in the total column.
G
Gord Dibben
Shell
I assume you are speaking of the Invoice Template from Spreadsheet Solutions.
The Unit Price column has Data Validation that will not allow negative numbers
or numbers greater than 1000000000.
You can change that if you select those cells and Data>Validation>Allow
Gord Dibben Excel MVP
I assume you are speaking of the Invoice Template from Spreadsheet Solutions.
The Unit Price column has Data Validation that will not allow negative numbers
or numbers greater than 1000000000.
You can change that if you select those cells and Data>Validation>Allow
Gord Dibben Excel MVP
D
Dave Peterson
Shouldn't the unit price always be positive?
When I try it just tells me I must enter a number. I am running office 2003.