View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
 
Posts: 46
Default 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