Help (FAQ)‎ > ‎

The format (or Locale) for my date, number or currency fields is lost. What can I do?

posted 1 Jan 2016, 10:27 by Andrew Dimech   [ updated 14 Feb 2017, 11:06 by Andrew Dimech ]

For example as shown in image below, the German date ‘3 Februar 1980’ will be merged to English ‘3 February 1980’. As a workaround do the following:

  1. Create another column (‘DOBMerge’ as in the example below)

  2. Use the =to_text(cell) formula to convert your field into text

  3. In your document use the *|DOBMerge|* field instead of the *|DOB|* field

  4. You are now ready to merge