0

How to format a column of numeric values with two decimal places and commas for thousands?

Bill Malcolm

January 26, 2019 19:56

None

Follow

What is the syntax to format a column of numbers xx,xxx.00?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis January 28, 2019 15:14

  Hello -

  As long as you are not dealing with an Excel table [e.g., using the NL(Table) function], there is a button for that on Excel's Home ribbon:

  

  When using the NL(Table) function, the column can be formatted AFTER you have run the report.