Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Vlookup Error, how to convert Text to Number | Excel Discussion (Misc queries) | |||
Big number error | New Users to Excel | |||
error while copying number from Notepad | Excel Discussion (Misc queries) | |||
Number Stored as text Error | Excel Worksheet Functions | |||
Counting the number of Error Types | Excel Worksheet Functions |