Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to format cells so the numbers are displayed like the general format
but with the thousands separator. I can't figure out how to insert the thousands separator without fixing the number of decimal places. For instance, I would like =1000*pi() to display as 3,141.59265 (showing as many decimal places as will fit in the cell). I would like =10 to display as 10 . Thanks for any hints. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting a number to look like a Percent without a percent sign | Excel Discussion (Misc queries) | |||
number formatting | Excel Discussion (Misc queries) | |||
Number formatting issue | Excel Worksheet Functions | |||
Number formatting | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions |