View Single Post
  #2   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

I dont know there may be some other solution

highlight the cells
click data(menu)-validation
in the datavalidation window
allow: <decimal
data <greaterthan
minimum .0000001
click ok

try to give some negative numbers and test.

in inputmessage write whatever you wish.

==============================


David J <David wrote in message
...
In Excel Villiage Software I want to do credit invoicing and it will only
allow positive numbers. Is it possible to do?