ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   format numbers with commas (https://www.excelbanter.com/excel-discussion-misc-queries/228092-format-numbers-commas.html)

slezama

format numbers with commas
 
In excel 2007, the commas to separate thousands do not insert for any number
past 999,999. For example, 12,999,999 is displayed as 12999,999, and not as
12,999,999. No format in <Format cell_number_format changes this. Is there
any way to do this?

JLatham

format numbers with commas
 
Answer from Gary''s Student in your other post of this same question:
http://www.microsoft.com/office/comm...1-b872878737fe


"slezama" wrote:

In excel 2007, the commas to separate thousands do not insert for any number
past 999,999. For example, 12,999,999 is displayed as 12999,999, and not as
12,999,999. No format in <Format cell_number_format changes this. Is there
any way to do this?



All times are GMT +1. The time now is 12:28 AM.

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