I live in the netherlands therefore I use the comma to indicate half or quarter etcetera. I imported a lot of tables having numbers that use the comma the other way. I want to change all the commas in those cells into dots.
Thank you so much for your help in advance:)
Robert
Hi Robert,
Depending on how you import those tables and your Locale settings those changes should be handled automatically.
However if the commas aren’t converted and you need to import those tables on a regular basis then I would recommend using a formula to do the job.
=SUBSTITUTE(A1;",";"") will remove the commas from the number in A1. Another issue that may occur is that the number 1000 represented as 1,000 will become 1 after import as the comma is now acting as a decimal point. If this occurs you will need to multiply values by 1000. Without seeing an example of the tables it is difficult to visualise the best approach.
Cheers,
John