User Profile
SeppT03
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Converting Text to numbers
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 Sepp5KViews0likes3CommentsConverting 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 be used as numbers and to do calculations. My system is set up with no thousand seperator and a comma as decimal i.e 10562,98. I dont want to change the settins as this will effect all my other spreadsheets. Is there a way to convert this text from its current form 10,562.98 to 10562,98 as a number format? Appriciate any help I can get, thank you Regards SeppSolved6KViews0likes14Comments
Recent Blog Articles
No content to show