| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding and dropping digits
Hello,
Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding and dropping digits
A1 = 567,549
=ROUND(A1,0) If this post helps click Yes --------------- Jacob Skaria "Marissa" wrote: Hello, Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding and dropping digits
=ROUND(A1,-3)
Custom format to #,##0, Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 10:30:01 -0700, Marissa wrote: Hello, Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding and dropping digits
Thank you but it did not work. The result was the number in A1.
"Jacob Skaria" wrote: A1 = 567,549 =ROUND(A1,0) If this post helps click Yes --------------- Jacob Skaria "Marissa" wrote: Hello, Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding and dropping digits
"Marissa" wrote:
Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. If you have 567,549 in one cell (A1) and you want 568 in another cell, you can do: =round(A1/1000,0) Similarly, if you have a formula in a cell (A1) and you want to change the formula so that it displays only thousands: =round((formula)/1000,0) The parentheses around "formula" may or may not be needed, depending on the formula. But if you want the cell value to remain 567,549 and only appear as 568, I believe you need a formatting option to do that, and I am not aware of any that does. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding and dropping digits
Errata....
"JoeU2004" wrote: But if you want the cell value to remain 567,549 and only appear as 568, I believe you need a formatting option to do that, and I am not aware of any that does. Duh, what Gord wrote, namely the custom format #,##0, Note the comma at the end. I missed it when I read Gord's posting. Also, no need to round to thousands first. ----- original message ----- "JoeU2004" wrote in message ... "Marissa" wrote: Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. If you have 567,549 in one cell (A1) and you want 568 in another cell, you can do: =round(A1/1000,0) Similarly, if you have a formula in a cell (A1) and you want to change the formula so that it displays only thousands: =round((formula)/1000,0) The parentheses around "formula" may or may not be needed, depending on the formula. But if you want the cell value to remain 567,549 and only appear as 568, I believe you need a formatting option to do that, and I am not aware of any that does. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Rounding and dropping digits
Marissa Sorry. Initially I read this as 567.549 instead of comma....
Gord has answered this..Cheers If this post helps click Yes --------------- Jacob Skaria "Marissa" wrote: Thank you but it did not work. The result was the number in A1. "Jacob Skaria" wrote: A1 = 567,549 =ROUND(A1,0) If this post helps click Yes --------------- Jacob Skaria "Marissa" wrote: Hello, Is there a way to round a number and than drop to only show a portion of it. For example: 567,549 to appear as 568. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up or down to specific decimal digits. | Excel Worksheet Functions | |||
| Excel is rounding off more than 16 digits ? | Excel Discussion (Misc queries) | |||
| How to truncate to tenths digits without rounding | Excel Worksheet Functions | |||
| excel, how enter 15 digits in a cell without rounding off last? | Excel Worksheet Functions | |||
| How do I keep Excel from dropping my numbers to 0 after 15 digits | Setting up and Configuration of Excel | |||
Linear Mode
