ExcelBanter

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/69868-re-how-do-i-format-numbers-thousands.html)

bpeltzer

How do I format numbers in thousands?
 
Format Cells, select the Number tab and choose the Custom category. In the
text box, enter #,##0,
That trailing ',' drops three digits (likewise ,, would give you millions).

"Barb" wrote:

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 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com