ExcelBanter - How to determine the cell contain number only?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to determine the cell contain number only? (https://www.excelbanter.com/excel-discussion-misc-queries/148650-how-determine-cell-contain-number-only.html)

Eric

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

Mike H

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

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