| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text detector
I'm stuck on creating a formula. Here's what i'm trying to do.
In a certain field an entry should be of numerical value only, no text, not dots no dashes. What i'm looking to do is return a value of 0 for anything that has anything other than a number in it. Is this possible? Thanks Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
| Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
| Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
| text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) | |||
| want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
![O2 andy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
