| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Data in Thousands in Excel 2007
Appreciate it if anyone could tell me how to make Excel 2007 display $
1,000,000 as $1000 on a spreadsheet only, as well as the whole document. Thanks for any assistance that you can provide. -- Django |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display Data in Thousands in Excel 2007
In the cells in question, create a custom format and use these
parameters: _(* #,##0.0,,_);_(* (#,##0.0,,);_(* "-"??_);_(@_) Dave O Eschew obfuscation |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display Data in Thousands in Excel 2007
To have $1000 displayed when 1,000,000 is in a cell, use a custom format of:
$0, Regards, Fred. "Django" wrote in message ... Appreciate it if anyone could tell me how to make Excel 2007 display $ 1,000,000 as $1000 on a spreadsheet only, as well as the whole document. Thanks for any assistance that you can provide. -- Django |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Display Data in Thousands in Excel 2007
Thanks Fred.
-- Django "Fred Smith" wrote: To have $1000 displayed when 1,000,000 is in a cell, use a custom format of: $0, Regards, Fred. "Django" wrote in message ... Appreciate it if anyone could tell me how to make Excel 2007 display $ 1,000,000 as $1000 on a spreadsheet only, as well as the whole document. Thanks for any assistance that you can provide. -- Django |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Excel 2007 data by states using United States (US) map | Excel Discussion (Misc queries) | |||
| Display external data inside of an Excel 2007 Spread sheet | Excel Worksheet Functions | |||
| Excel 2007 - hyperlink to display external data in a pop-up? | Excel Worksheet Functions | |||
| how to display numbers in thousands i.e display 10,000 as 10 | Excel Worksheet Functions | |||
| how do I display number in thousands; i.e diplay 123,500 as 124? | Excel Worksheet Functions | |||
Hybrid Mode
