| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| removing commas from numbers etc. | Excel Worksheet Functions | |||
| Help! I need a formula to add numbers separated by commas within | Excel Worksheet Functions | |||
| File Convert With commas to txt format | Excel Discussion (Misc queries) | |||
| Pasting Numbers with Commas from Outside Source | Excel Discussion (Misc queries) | |||
| how do i build commas on numbers in india system | Excel Discussion (Misc queries) | |||
Linear Mode
