Limiting Cell to negative values only

[David In OC California]

I am looking to limit certain cells to accept only values that are negative, including zero. No positive numbers and no apha characters as well. How do I do this? Once I protect the worksheet does that limit the cells as it does for my "locked cells"?

 

[T. Valko]

I am looking to limit certain cells to accept only values that are negative, including zero. No positive numbers and no apha characters as well. How do I do this? Once I protect the worksheet does that limit the cells as it does for my "locked cells"?

You can do that with data validation.

What version of Excel are you using?

 

[David In OC California]

I am using Excel with MS Office Prof 2010. Shows version 14

 

[T. Valko]

I am using Excel with MS Office Prof 2010. Shows version 14

Ok, that should be the same as it is in Excel 2007...

Select the range of cells in question
Goto the Data tab
In the Data Tools group select Data Validation
Allow: Decimal
Data: Less than or equal to
Maximum: 0
OK out

 

[David In OC California]

This is perfect.. Beautiful, thank you!!!!

 

[T. Valko]

This is perfect.. Beautiful, thank you!!!!

You're welcome. Thanks for the feedback!