Locked spreadsheet, without cents
Hi Julie,
Highlight your cell or cells and goto DataValidation.
From the dropdown menus select
Allow:
Whole Number
Data:
Greater than
Number:
0
Click OK and you are done
Test out a few fifferent combos to get the right one for your job.
HTH
Martin
|