Number format not displaying as expected

Issue

The numbers in the MerlinXL reports are not displayed in the expected format.

Solution 1

In Excel check  File | Options | Advanced  and ensure  the option “Use system separators” is checked.

Solution 2

In HFM Workspace  check File | Preferences | Consolidation  and ensure that the Decimal separator is set to . (full stop)  and the Thousands separator is set to , (comma)