please convert these "numbers" to actual numbers

[stvbrown2184]

Excel will not let me multiply the values in Column A
Book2.xlsx

thanks you

[AlKey]

Try this formula

=IFERROR(SUBSTITUTE(A2,CHAR(160),"")+0,"")

[Sam Capricci]

Open find and replace, go into cell A2, highlight the space that is to the left of (or precedes) the 97.00, paste it into find, leave replace blank, highlighting column A, then hit replace all and it will convert them to numbers.

[stvbrown2184]

THANKS!!! this has saved me so much time

[Pete_UK]

You can use this formula in B2:

=IF(SUBSTITUTE(A2,CHAR(160),"")="","",1*SUBSTITUTE(A2,CHAR(160),""))

then copy down. An alternative (slightly shorter) is:

=IFERROR(1*SUBSTITUTE(A2,CHAR(160),""),"")

Hope this helps.

Pete

[Richard Buttrey]

Hi,

The 'numbers' have a preceding and trailing character code 160. Try:

Please Login or Register  to view this content.