View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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 DataValidationAllow


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 02:55:01 -0800, "389Shell"
wrote:

When I try it just tells me I must enter a number. I am running office 2003.