#1   Report Post  
David J
 
Posts: n/a
Default credit invoicing

In Excel Villiage Software I want to do credit invoicing and it will only
allow positive numbers. Is it possible to do?
  #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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When we enter a 16 digit number (credit card) the last digit chan. ceking Excel Discussion (Misc queries) 5 December 8th 04 11:45 PM
How can I stop Excel from displaying rounded numbers? Credit car. OldManP Excel Discussion (Misc queries) 3 December 8th 04 07:52 PM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"