| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the cell contain number only?
Does anyone have any suggestions on how to determine the cell contain number
only / in any number format? such as in cell A1, which contains "A12345", then in cell B1 it returns false. In cell A1, which contains 12345, then in cell B1 it returns true. Thank for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to determine the cell contain number only?
Try,
=ISNUMBER(A1) Mike "Eric" wrote: Does anyone have any suggestions on how to determine the cell contain number only / in any number format? such as in cell A1, which contains "A12345", then in cell B1 it returns false. In cell A1, which contains 12345, then in cell B1 it returns true. Thank for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the number of workday between two periods? | Excel Worksheet Functions | |||
| How to determine the number in excel? | Excel Discussion (Misc queries) | |||
| How to determine the number of units? | Excel Discussion (Misc queries) | |||
| Determine number of days | Excel Worksheet Functions | |||
| How do I determine the number of cell formats in this workbook | Excel Discussion (Misc queries) | |||
Linear Mode
