View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron[_32_] Ron[_32_] is offline
external usenet poster
 
Posts: 36
Default 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