You Must Enter A Number In This Cell
 

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

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

"la90292" wrote in message
. com...
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

"la90292" wrote in message
. com...
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 DataValidation.

Ian

Thanks, that was the problem. Cheers, victor

"la90292" wrote in message
. com...
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