| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting commas
Excel does not insert commas for figures over 999,999. For example instead of
displaying 12,999,999 as shown, it displays it as 12999,999. There is no way to change the display format. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inserting commas
Format Cells... Number Custom ###,###,###
This will cause 123456789 to be displayed as 123,456,789 -- Gary''s Student - gsnu200847 "slezama" wrote: Excel does not insert commas for figures over 999,999. For example instead of displaying 12,999,999 as shown, it displays it as 12999,999. There is no way to change the display format. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Commas in Excel | Excel Discussion (Misc queries) | |||
| So many commas | Excel Worksheet Functions | |||
| help commas before data | Excel Discussion (Misc queries) | |||
| Missing commas | Excel Worksheet Functions | |||
| Removing commas | Excel Worksheet Functions | |||
Hybrid Mode
