| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a number to cut off the thousands?
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
|
|||
|
|||
|
How do I format a number to cut off the thousands?
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
