ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   whole number error? (https://www.excelbanter.com/excel-discussion-misc-queries/193436-whole-number-error.html)

shane

whole number error?
 
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?

tim m

whole number error?
 
Perhaps look at 'Conditional formatting' and clear out any condition that has
been placed on that cell.

"Shane" wrote:

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?


Pete_UK

whole number error?
 
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

On Jul 2, 5:21*pm, Shane wrote:
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?




All times are GMT +1. The time now is 02:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com