Issue with Excel decimal separators

  • 31 August 2023
  • 1 reply

Badge +4


I’m working with an Excel file that has numbers with commas (3,000) and dot (3.000)  decimal separators (both numbers are three thousand). This is giving me errors. How can i change the numbers so the type of decimal separator does not matter? Is there any way I can work around this using AA? 


1 reply

Userlevel 6
Badge +15

Hi @jsegura 2409 ,

Please follow the below,

To work with an Excel file that has numbers with both commas and dots as decimal separators, you can use Automation Anywhere to standardize the format and ensure that the type of decimal separator doesn't matter. Here's a step-by-step guide on how to do this:

  1. Open Excel File:

    • Use Automation Anywhere to open the Excel file that contains the data.
  2. Read Data:

    • Use Automation Anywhere's Excel Packages to read the data from the file into a data table or a variable.
  3. Standardize Decimal Separators:

    • Iterate through each cell or row in the data table.
    • For each cell containing a number, use Automation Anywhere string manipulation commands to replace any commas with dots or vice versa. You can use the Replace function to do this.
  4. Save Changes:

    • Use Automation Anywhere to save the changes back to the Excel file.
  5. Close Excel File:

    • Finally, close the Excel file using Automation Anywhere Excel Package Actions.