Downloading History statement as Excel file

When I move my downloaded history statement into an excel file or Google sheet the balance column is read as text. I have tried tor reformat the column but the number has a space in between the 1000 and 100 numbers. How can this problem be fixed from the time of download? All the numbers should be numbers! 

Also, there is no column for set stop loss or TP that was set at the time of the trade. Only closing price. When analyzing my data I need to look at risk ratios and need the TP and stop loss to do that. How can these be added to the history statement or is there another way to download this data all together?

Thank you,

Meir