Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Does anyone know how I could automatically format a number to change from
1,776,176 to 1,776? I can insert a round number but it doesn't drop the 000's. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Use custom format 0,; to show thousands
Or 0,,; to show millions Remember that this will NOT alter the stored value, only the display best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Nikki" wrote in message ... Does anyone know how I could automatically format a number to change from 1,776,176 to 1,776? I can insert a round number but it doesn't drop the 000's. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number Format
Hi,
Use this =ROUND(A1/1000,0) change the cell reference as it suits you -- _______________________ Click "Yes" if it helps ________ Thanks Suleman Peerzade "Nikki" wrote: Does anyone know how I could automatically format a number to change from 1,776,176 to 1,776? I can insert a round number but it doesn't drop the 000's. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
excel format cells/Number/Category: Number problem | Excel Discussion (Misc queries) |