| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I round a number to the nearest thousand in Excel???
Try
Format Cells Number Custom In the "Type" box enter #,##0, This chanes the format while keeping the precision of the number of future calculations. "Dave F" wrote: Assuming the value is in A1, then =LEFT(ROUND(A1,0),3) would return the thousands value. -- Brevity is the soul of wit. "Round 123,456 to read 123" wrote: Hi need help fast.... I need to round my number to the nearest thouseand. Example 123,456.7890 I want it to read 123 I formatted to the deimal is rounded but can't round the comma.... I tried the custom cell formatting options...No Luck HELP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| How do I round down to nearest .05% in Excel? | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
| Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
Hybrid Mode
