Importing numbers from external source: how to convert text in numbers

[Nelson78]

Hello everybody.

I'm struggling with sums.
I mean: I've just imported data from an external source.

https://imgur.com/a/7ln2Ti6

As you can see in the image, in the column "Amount" I've imported number, but if I select all (or apply whatever formula), nothing happens in terms of calculating total.

If I enter each cell and press enter, then text is shifted on the right of the cell and converted in numbers (see column on the right).

How can I arrange this problem in vba?

Thank's.

 

[SpillerBD]

Record a Macro using the Text To Columns feature and modify to suit.
There can be an issue with Non-Breaking Space characters depending on your source, CHAR(0160).

If it turns out you need to remove those characters, this snippet can take care of them by removing.
Alternatively, you mad need to change them to a normal space character.

Sub Code_160()
'
' Code_160 Macro
'Removes all Characters of Code 0160 from Active WorkSheet
'This Character Code is often included in copied or downloaded
'spreadsheet data that interferes with Excel evaluations.
'Add to the QAT with suitable Icon. Suggestion is the "Unhappy" Face

    Cells.Replace What:=" ", Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End Sub