I need to set up a spreadsheet to provide to various users to complete on a monthly basis. The have to fill in only about 7 columns of information - I would like to restrict what cells they can access and what can be entered -- for example:
Customer Name -- text restricted to 40 characters
Comments - restricted to 100 characters (but want data to word wrap)
Cost - restricted to whole dollars - format with $ and no decimal places
Sold Date: restricted to a mm/dd/yy format
I looked a data validation but that didn't seem to work for me. Any direction you could provide would be appreciated.
I have done this in Word before - but not in Excel. Thank you!