Unknown Data Type

[JesseH]

I copied and pasted data from the internet to excel. It looks good. The numeric data is "type 2". I have tried to format it to number. Did not work. I tired, Value(xx). I tried value(text(xx)). Did not work. I need to convert it to a numeric field to sort correctly and do arithmetic calculations. Any ideas?

Thanks in Advance

JesseH

 

[SkipVought]

JesseH,

The numeric data is "type 2".

???

The data in the quotes is TEXT. Do you want to get rid of the alpha part?

Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]

 

[JesseH]

Skip, type 2 is text.

 

[JesseH]

Skip, this a sample of the data. Note order. It is already sorted.

Count
 1010
 107
 1105
 112
 112
 1129
 114
 117
 119
 128
 132
 134
 139098
 141
 1411

 

[SkipVought]

you had a non-printabla character in the first position
[tt]
=VALUE(RIGHT(A1,LEN(A1)-1))
[/tt]


Skip,
[sub]
[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [/sub]