Forum Discussion

SeppT03's avatar
SeppT03
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
SeppT03's avatar
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's avatar
    Lorenzo
    Silver Contributor
    Apr 19, 2023
    Glad you have a solution & Thanks for providing feedback

Resources