Number format changing when creating doc

[Clare]

I'm trying to merge some data for a French document and need my currency data to be displayed as 33,00€ (note the comma rather than decimal point).

The currency fields are correctly formatted to the French format in my Sheet, but Autocrat seems to be switching the data back to 33.00 during the merge.

Is there anything I can do to stop this? 

I've formatted all the fields in the Sheet and switched my docs and drive to French but I'm still not having any success.

Thanks,

Clare

[Joseph Schmidt]

Use the same solution that is explained for dates in the FAQ.  The formatting is lost during the merge so you have to create a text column.  You can use an Arrayformula instead of CopyDown if you choose.

Dates don’t appear correctly in the merged document?

autoCrat supports a number of date formats, but not all.  Common failures are non-American date formats. If autoCrat is not merging a date the way you like, the solution is to use the text() function in a separate column.  If you want this to work on a form submission sheet, you should also install the copyDown add-on.

• If your date is in column A put a version of the following formula in another column = text ( A2, “dd/mm/yyyy”)  OR = text ( A2, “dd/mm/yyyy hh:mm a”)

In case you’re curious:

There are two dates in a cell:  The date you see, which incorporates the format you have applied, and the underlying date “object” that your spreadsheet sees.  The object has much more information than you probably need (seconds, timezone, etc.).

When autoCrat runs a merge, it uses a third party library that looks at the formatting you have applied to the spreadsheet, and also applies it to the date.  Not all formats are supported, though the list is growing. If the format chosen is not supported, autoCrat falls back to a default date string.

Joe Schmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/11d09096-e8af-4058-a807-7fd19d118399%40googlegroups.com.

[Nicolas Leon]

I used the following code for formatting euros with comma and point:

=TEXT(A1;"#,##0.00 €")

Example:

A2 = 25789

B2 = TEXT(A2;"#,##0.00 €") 

B2 shows: 25.789,00 € (which is the european standard)

For reference use: https://www.benlcollins.com/spreadsheets/google-sheets-custom-number-format/ 

Nicolas