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

Configuring Default Numeric Formatting in Excel Output

Avatar photoCustomer August 6, 2019 at 7:51 am

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support August 7, 2019 at 12:04 pm  

      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 August 8, 2019 at 2:24 pm  

      What is the default numeric format?

    • Support August 9, 2019 at 7:13 am  

      The default is ‘General’.

    • Avatar photoCustomer August 10, 2019 at 7:32 pm  

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

    • Support August 12, 2019 at 8:46 pm  

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

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: