When you export a CSV data file from the sheet, the numeric fields display according to your Preferences settings (the number format options settings). The following provides additional information:
- In Unifier functionalities that allow export and import of data through a CSV file, the currency symbol and digit grouping symbol are not displayed.
- In Unifier functionalities that allow only exporting of data but not importing data through a CSV file, the currency symbol and the digit grouping symbol are displayed.
- In Unifier functionalities that allow only exporting of data but not importing data through a CSV file, the negative numbers display according to your Preferences settings.
- Decimal symbol display according to your Preferences settings.
- In Unifier functionalities, which allow exporting and importing of data through a CSV, the negative numbers, if any, displays as: -<Number, Decimal Symbol, Number> (Example: -100000,99 – The decimal symbol is comma)
- If there are any date fields, then the dates are formatted based on your Preferences settings.