How do I format a cell for accounting only

I have created a spreadsheet and have figured out how to protect cells so that the formulas can not be changed or accidentally deleted. Is there a way to format other cells so that it will not let the user enter anything other than numbers?


Thanks

Hi
You can use data validation for this.
First select your cells to be restricted then go to Data/Validation, select custom from the list and in the formula box put this:
=ISNUMBER(A1)
A1 being the cell to be restricted. Will work on a large selection but not on multiple selections. If you select a large area use the first cell as the formulas reference.

Hope that helps!
Jean-Guy

That worked perfectly!!!!

Thanks. I had been trying to figure it out for days.

Thanks Again,
Scott