You Must Enter A Number In This Cell

[la90292]

I have the respective cells formatted to General and have made sure that the
work sheet is unprotected. I have also check for any formulas that might
refer to these range of cells--there are none.

Each time I attempt to enter the color of the item in this cell, i.e. black,
I receive the above message.

Please help.

Thanks, victor

 

[Paul B]

La, could be data validation, click on the cell and then go to data
validation and see if there is anything there

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[IC]

I have the respective cells formatted to General and have made sure that the
work sheet is unprotected. I have also check for any formulas that might
refer to these range of cells--there are none.

Each time I attempt to enter the color of the item in this cell, i.e. black,
I receive the above message.

Check Data>Validation.

Ian

 

[la90292]

Thanks, that was the problem. Cheers, victor