| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is it possible to show numbers in thousands and decimals
Is it possible to show whole numbers rounded to thousands and the hundreds
shown as decimals? Ex. 1,234,567 to show as 1,234.56 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to show numbers in thousands and decimals
go Format cells, custom, change to #,###.##,
but in your example, it should round up to 1,234.57 "slac" wrote: Is it possible to show whole numbers rounded to thousands and the hundreds shown as decimals? Ex. 1,234,567 to show as 1,234.56 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible to show numbers in thousands and decimals
=A1/1000
and custom format #,###,###.00 On Feb 4, 8:05*am, slac wrote: Is it possible to show whole numbers rounded to thousands and the hundreds shown as decimals? Ex. *1,234,567 to show as 1,234.56 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| round numbers in the millions to numbers in the thousands | Excel Worksheet Functions | |||
| How do I change the character separating thousands or decimals on. | Excel Discussion (Misc queries) | |||
| Show numbers in thousands thru Format Cell | Excel Discussion (Misc queries) | |||
| Format numbers to thousands | Excel Discussion (Misc queries) | |||
| How do I format numbers in thousands? | Excel Discussion (Misc queries) | |||
Linear Mode
