Exporting a CSV File With or Without Import Support

When you export a CSV file from a sheet (Cost Sheet, Funding Sheet, and so on), numeric fields display according to your Preferences number format options.

The following rules apply:

  • In features that support both export and import through a CSV file, the currency symbol and digit grouping symbol are not displayed.
  • In features that support export only through a CSV file, the currency symbol and digit grouping symbol are displayed.
  • In Unifier features that support export only through a CSV file, negative numbers display according to your Preferences.
  • The decimal symbol displays according to your Preferences.
  • In features that support both export and import through a CSV file, negative numbers display in the format -<Number, Decimal Symbol, Number>. For example, if the decimal symbol is a comma, a negative number displays as -100000,99.
  • If the file includes date fields, the dates are formatted according to your Preferences.