ExcelBanter - How do I format numbers in thousands?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format numbers in thousands? (https://www.excelbanter.com/excel-discussion-misc-queries/69877-how-do-i-format-numbers-thousands.html)

Barb

How do I format numbers in thousands?

How can I show whole numbers rounded to thousands by dropping the zeros?

Ex. 1,234,567 to show as 1,234

All times are GMT +1. The time now is 09:04 AM.