Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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.