| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I round a number to the nearest thousand in Excel???
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round a number to the nearest thousand in Excel???
Hello, Round!
You wrote on Thu, 14 Sep 2006 08:19:03 -0700: Rtr Hi need help fast.... Rtr I need to round my number to the nearest thouseand. Rtr Example 123,456.7890 Rtr I want it to read 123 Rtr I formatted to the deimal is rounded but can't round the Rtr comma.... I tried the custom cell formatting options...No Rtr Luck HELP HELP is what to use! Anyway, =round(a1/1000,0) James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.comcast.not |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I round a number to the nearest thousand in Excel???
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 |
|
#4
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 | |||
Linear Mode
