Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need to format an entire set of financials to reflect all numbers rounded
to thousands - i.e. 1,234,567 should show up as 1,235. Any ideas?? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Liz.
Try a Custom format of: #,###, -- HTH Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Liz" wrote in message ... I need to format an entire set of financials to reflect all numbers rounded to thousands - i.e. 1,234,567 should show up as 1,235. Any ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
number format | Excel Discussion (Misc queries) | |||
Format Number to Text | Excel Worksheet Functions | |||
Format number as text on import | Excel Discussion (Misc queries) | |||
Telephone number format | Excel Discussion (Misc queries) |