Decimal Formatting Issue when Exporting Numbers to Google Sheets from Make

How To
1

Problem Description:

When exporting a decimal number from Make to a Google Sheets spreadsheet, the value loses the desired format (with a comma as the decimal separator) and either changes to a number with a period as the decimal separator or is incorrectly interpreted as a date in Google Sheets.

Details:

  1. Parameter: value_Example (decimal number), example value: 1342,50.
  2. Process in Make:
  • The value_Example parameter is transformed in Make to be exported as 1.342,50, using various function combinations such as formatNumber, replace, and toString.
  • Despite multiple formatting attempts, the value continues to display two types of errors in Google Sheets:
    • Error 1: The number converts to an undesired format like 1.342.50 or 1342.5.
    • Error 2: The value is interpreted as a date (e.g., 1/05/1342).
  1. Google Sheets Configuration:
  • Several cell formats have been tried, including Plain Text and others, without success.
  • Google Sheets continues to automatically interpret the values regardless of the configurations applied in both Make and the spreadsheet.

Steps to Reproduce:

  1. Create a scenario in Make that generates a decimal number with a comma as the decimal separator.
  2. Attempt to export this number to Google Sheets using the Add a Row module.
  3. Test different configurations in Make to ensure that the numeric format remains intact (e.g., replace, formatNumber).
  4. Observe in Google Sheets that the value appears in an undesired format or as a date.

Expected Behavior:

The exported value should maintain the original decimal format (with a comma as the decimal separator) without adding thousands separators or converting it to a date.

Observed Behavior:

  • The decimal value changes, displaying thousands separators or converting to date format in Google Sheets.

Attempts to Solve:

  • Tried functions formatNumber, replace, toString in various combinations.
  • Set the cell format in Google Sheets to Plain Text.

Additional Context:

  • Country / Regional setting in Google Sheets: Set to Spanish (Spain).
  • Affected Module: Google Sheets - Add a Row.

I would appreciate any guidance on how to preserve the decimal format with a comma when exporting from Make, or if there are additional settings in Make or Google Sheets that can prevent automatic date formatting and thousands separators.

Thank u!