Forum Discussion
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...
SeppT03 Another option is to use 'Text to Columns' (found under DATA -> Data Tools group). The first couple pages the default should be ok and then under Advanced you can tell it to recognize the opposite separators:
Many roads lead to Rome...and even more roads lead to a result in Excel! :)) "(Y)"
- so true. I need to try to remember to use that saying about Rome instead of always using the saying about ways to skin a cat ... why in the world do we talk about many ways to skin a cat any how?