Home › Discussions › Questions & Answers › Configuring Default Numeric Formatting in Excel Output

Configuring Default Numeric Formatting in Excel Output

Avatar photoCustomer Questions & Answers 5 replies

We need all numeric columns to default to a specific format (e.g., currency with two decimal places). Which profile option defines the default numeric format string?

5 replies

  • Support Enginatics

    You should set the profile option ‘Blitz Report XLSX Number Format’. This defines the numeric column format string for Blitz Report XLSX output files.

  • Avatar photoCustomer

    What is the default numeric format?

  • Support Enginatics

    The default is ‘General’.

  • Avatar photoCustomer

    Does this default format apply if a number format is set for an individual column?

  • Support Enginatics

    The format can be set by this profile option for all columns, or for individual columns as described in the column translations section.

  • You must be logged in to reply to this post.