| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells wanting numbers only
How do you force a cell to prefer numbers only?
I have a workbook that has certain cells that expect numbers to be entered. If I try to enter something other than a number, I get a message stating, "You must enter a number in this cell. ...Continue?" I've been trying to find what's causing this message and how it knows if a number is entered or not. I would suspect VBA, but I cannot find any code in modules or on the individualtried sheets or ThisWorkbook. It's possible that the code is hidden. Any ideas how I can find it? Thanks, Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cells wanting numbers only
Sorry,
My brain had a glitch on that one. I figure out it was 'Data Validation'. Thanks anyway, Paul "PCLIVE" <pclive(remove wrote in message ... How do you force a cell to prefer numbers only? I have a workbook that has certain cells that expect numbers to be entered. If I try to enter something other than a number, I get a message stating, "You must enter a number in this cell. ...Continue?" I've been trying to find what's causing this message and how it knows if a number is entered or not. I would suspect VBA, but I cannot find any code in modules or on the individualtried sheets or ThisWorkbook. It's possible that the code is hidden. Any ideas how I can find it? Thanks, Paul |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Cells wanting numbers only
Look at:
Data Validation... -- Gary's Student "PCLIVE" wrote: How do you force a cell to prefer numbers only? I have a workbook that has certain cells that expect numbers to be entered. If I try to enter something other than a number, I get a message stating, "You must enter a number in this cell. ...Continue?" I've been trying to find what's causing this message and how it knows if a number is entered or not. I would suspect VBA, but I cannot find any code in modules or on the individualtried sheets or ThisWorkbook. It's possible that the code is hidden. Any ideas how I can find it? Thanks, Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not wanting #div/0 to chart as zero | Charts and Charting in Excel | |||
| Not wanting to plot #div/0 | Charts and Charting in Excel | |||
| Wanting to sum a colum of numbers and then roundup to the next dol | Excel Worksheet Functions | |||
| Wanting to know if this is possible | Excel Discussion (Misc queries) | |||
| Wanting to add best 3 out of 4 numbers in Excel? | Excel Programming | |||
Linear Mode
