Converting text amount to a number that excel sees as numbers and not text

[Riaang]

Hi there,

I have copied a dataset from word to excel but now excel does not recognize the amounts as numbers so I cant do any calculations. The numbers appear as 3 258 124. I've tried to remove the spaces but excel cant find any spaces so it must be a special character.

Please help.

Thanks

Riaan

 

[sheetspread]

If the 3 258 and 124 are in separate cells, then type 1 in a blank cell, copy, and paste special multiply to the range (or add 0, etc). If they're in the same cell you can use the code function with mid() to get the ascii then substitute.