whole number error?

S

Shane

When I enter a number higher than 155 into a particular cell, I receive a
message "must be a whole number", little message window with an X through a
red circle. Don't know if its a custom message created by previous user or
an excell error? How can I fix?
 
T

tim m

Perhaps look at 'Conditional formatting' and clear out any condition that has
been placed on that cell.
 
P

Pete_UK

That sounds like a message from Data Validation applied to the cell.
Select the cell and click on Data | Validation then on the Clear All
button.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top