Forum Discussion

Copper Contributor

Apr 19, 2023

Solved

Converting Text to numbers

I have statements in CSV format converted to text in excel. Pproblem the numbers are seperated with a comma as the thousand seperator and a dot for the decimal i.e. 10,562.98. They can therefore not...

Formulas and Functions

Lorenzo
Apr 19, 2023
SeppT03
NUMBERVALUE does it - see attachment columns F-G
Account Balance History Converted.xlsx15 KB

SeppT03

Copper Contributor

Apr 19, 2023

NikolinoDE

Hi Nicolino,
Thanks again for your response.
The formula is copied and correct, incl (=).

I work on windows 11, and Office 365, 64 bits.

I've attached both files, the CVS and the xlsx, perhaps this makes it easier.

Thanks again for your assistance

Regards

Sepp

Account Balance History Converted.xlsx13 KB

Account Balance History.csv3 KB

Lorenzo

Silver Contributor

Apr 19, 2023

SeppT03

NUMBERVALUE does it - see attachment columns F-G

Account Balance History Converted.xlsx15 KB

SeppT03
Copper Contributor
Apr 19, 2023
Lorenzo
Awesome, thank you very much, your assistance is greatly appreciated.
Also thank you to everyone else that has tried to sort this.

Kind regards

Sepp
- Lorenzo
  Silver Contributor
  Apr 19, 2023
  Glad you have a solution & Thanks for providing feedback