Convert text numbers to numbers

[Tagaffney]

Can't convert these text numbers to numbers. Tried all possible methods, no luck

8.75
17.51
23.96
30.55
34.99
10.94
8.75
10.94
39.29

Numbers copied from a SODA PDF excel conversion spreadsheet of a Bank Statement PDF download.

 

[Richard U]

what methods did you try?

You may have thought you tried everything, but I'm sure we can help.

Just let us know what you did

 

[MARZIOTULLIO]

[h=1]Convert Text to Numbers or Numbers to Text[/h]
https://www.youtube.com/watch?v=92DHgCfsAbA

 

[Dave Patton]

What is the character to the right of the number?

Excel 2010
	A	B	C	D
1	8.75	8.75		160
2	17.51	17.51
3	23.96	23.96
3b

Cell Formulas
Range	Formula
B1	=IF(ISNUMBER(A1),A1,LEFT(A1,LEN(A1)-1)+0)
B2	=IF(ISNUMBER(A2),A2,LEFT(A2,LEN(A2)-1)+0)
B3	=IF(ISNUMBER(A3),A3,LEFT(A3,LEN(A3)-1)+0)
C1	=RIGHT(A1)
D1	=CODE(C1)

 

[Tagaffney]

what methods did you try?

You may have thought you tried everything, but I'm sure we can help.

Just let us know what you did

Copy/paste multiply, add 0, etc
=Value()
DATA, Text to Cols
=Substitution()
to Word then to Excel

and a few other I can't bring to mind
I've played around with the problem for a few hours. I'm not a real experienced Excel man, too

Thanks, Tom

 

[Tagaffney]

what methods did you try?

You may have thought you tried everything, but I'm sure we can help.

Just let us know what you did

1 This Seems to work Copy/paste +0 = Enter
16.41 TRUE #VALUE ! #VALUE ! 16.41 16.41+0 $16.41 FALSE FALSE TRUE
8.75 TRUE #VALUE ! #VALUE ! 8.75 8.75+0 $8.75 FALSE FALSE TRUE
10.78 TRUE #VALUE ! #VALUE ! 10.78 #VALUE ! $0.00 FALSE FALSE TRUE
353.44 TRUE #VALUE ! #VALUE ! 353.44 FALSE FALSE FALSE
46.63 TRUE #VALUE ! #VALUE ! FALSE FALSE FALSE
149.78 TRUE #VALUE ! #VALUE !
8.75 TRUE #VALUE ! #VALUE !
18.41 TRUE #VALUE ! #VALUE !
42.30 TRUE #VALUE ! #VALUE !
62.61 TRUE #VALUE ! #VALUE !
55.00 TRUE #VALUE ! #VALUE !
490.57 TRUE #VALUE ! #VALUE !
54.64 TRUE #VALUE ! #VALUE !
42.67 TRUE #VALUE ! #VALUE !
14.18 TRUE #VALUE ! #VALUE !

 

[philwojo]

I am using xl2013, do you have the function 'numbervalue' available to you? That seemed to work for me.

 

[Scott Huish]

Select your column.
Click on Data, then Text to Columns
Click Finish

 

[Tagaffney]

Select your column.
Click on Data, then Text to Columns
Click Finish

Did this work for you? Are they numbers and not text. Are you are to format them?? or, say, sum them??

I can't. They just remain text, for me??

 

[MiKos23]

Try this,

in one blank cell, type 1 and press enter. Highlight this cell press control+c
Highlight cells that you want to change to numbers, right click and choose paste special option. In the operation part of the paste special choose Multiply