| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - How to display 761000 in a cell as 761
In Excel 2003 I want to display 761000 in the cell as 761. The column header
is "$ in thousands", so I don't want to use the last three zeros in each cell. How do I format the cell to display 761,000 as 761? I already have a round function in this cell to round the number 760507 to 761000. Thanks, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 - How to display 761000 in a cell as 761
Try a custom format of:
0, (zero comma) Lacey Tree wrote: In Excel 2003 I want to display 761000 in the cell as 761. The column header is "$ in thousands", so I don't want to use the last three zeros in each cell. How do I format the cell to display 761,000 as 761? I already have a round function in this cell to round the number 760507 to 761000. Thanks, -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 - How to display 761000 in a cell as 761
Thanks Dave! I don't understand why or how this worked, but it did.
"Dave Peterson" wrote: Try a custom format of: 0, (zero comma) Lacey Tree wrote: In Excel 2003 I want to display 761000 in the cell as 761. The column header is "$ in thousands", so I don't want to use the last three zeros in each cell. How do I format the cell to display 761,000 as 761? I already have a round function in this cell to round the number 760507 to 761000. Thanks, -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I format a cell in excel to display 0.5 hrs as 00:30 | Excel Discussion (Misc queries) | |||
| Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
| How can I get my Excel 2003 sheet to display cell shading? | Excel Discussion (Misc queries) | |||
| cell format for date/time in same cell excel 2003 | Excel Worksheet Functions | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Linear Mode
