Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I identify a number from text in a list?
Hi all,
How can I identify what is a number and what is text & number in a list? I have a long list of values like so.. t4 f0 c6 a6 14 n5 t5 t6 12 e6 e8 a1 e1 12 e8 11 11 As the list is populated the numbers end up to the right of the cell, obviously being identified as numbers by excel. I want to differentiate between these numbers and the number & text values in the other cells. Could someone point me to a method please? Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I identify a number from text in a list?
Use the ISNUMBER() function
-- Kind regards, Niek Otten "Ron" wrote in message ... Hi all, How can I identify what is a number and what is text & number in a list? I have a long list of values like so.. t4 f0 c6 a6 14 n5 t5 t6 12 e6 e8 a1 e1 12 e8 11 11 As the list is populated the numbers end up to the right of the cell, obviously being identified as numbers by excel. I want to differentiate between these numbers and the number & text values in the other cells. Could someone point me to a method please? Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I identify a number from text in a list?
Niek,
Thankyou, just what I needed. Ron "Niek Otten" wrote in news:u7WnwNp8FHA.3200 @TK2MSFTNGP11.phx.gbl: Use the ISNUMBER() function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify Whole Number | Excel Discussion (Misc queries) | |||
simple: Identify a cell that is out of number sequence in a list | New Users to Excel | |||
how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
How to identify text from a autofiltered list using formulas | Excel Worksheet Functions |