Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
CELLS HAVING SAME NUMBER BY CHANGING ANY CELL | Excel Discussion (Misc queries) | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) |