| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format numbers to millions
Hi there, I saw an article in this web about formatting a number to million using the following format: #,##0,, ;[Red](#,##0,,);- ; So, if I have 1,777,777 I will get 2. However, what if I want to display 2,000,000 instead of only 2? How can I do that? Thank you. -- tinybunny_8 ------------------------------------------------------------------------ tinybunny_8's Profile: http://www.excelforum.com/member.php...o&userid=31070 View this thread: http://www.excelforum.com/showthread...hreadid=507477 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change format of page numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| cell format in Excel 2002 SP3 will not accept long numbers | Excel Worksheet Functions | |||
| Conditional format numbers | Excel Worksheet Functions | |||
| Using Replace to Format Negative Numbers | Excel Discussion (Misc queries) | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Threaded Mode
