ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rounding to thousands in excel (https://www.excelbanter.com/excel-discussion-misc-queries/159906-rounding-thousands-excel.html)

[email protected]

Rounding to thousands in excel
 
Does anyone know of a way to round to thousands in excel with a custom
format. I am trying to round as follows:

If the number is 49,677,298.86 I want 49,600 to display
If the number is 3,037,136.67 I want 3,000 to display
If hte number is 2,369,098.33 I want 2,400 to display

Thanks for your help.


ShaneDevenshire

Rounding to thousands in excel
 
Hi,

You have two issues here you are trying to format and to round down. You
can handle the formatting by:

Create the custom format #,###,

The rounding will require something like:
=ROUNDDOWN(H11,-5)


--
Cheers,
Shane Devenshire


" wrote:

Does anyone know of a way to round to thousands in excel with a custom
format. I am trying to round as follows:

If the number is 49,677,298.86 I want 49,600 to display
If the number is 3,037,136.67 I want 3,000 to display
If hte number is 2,369,098.33 I want 2,400 to display

Thanks for your help.



JE McGimpsey

Rounding to thousands in excel
 
Hmm...

(1) What rounding rules are you proposing? Your first example rounds
DOWN, your third example rounds UP.

(2) With that, your example rounds to hundred thousands, not thousands -
there's no way to do that just with formatting. You can round to the
closest 100,000 with:

=ROUND(A1,-5)


To round just the display to *thousands*:

Format/Cells/Number/Custom #,##0,

In article . com,
wrote:

Does anyone know of a way to round to thousands in excel with a custom
format. I am trying to round as follows:

If the number is 49,677,298.86 I want 49,600 to display
If the number is 3,037,136.67 I want 3,000 to display
If hte number is 2,369,098.33 I want 2,400 to display

Thanks for your help.


[email protected]

Rounding to thousands in excel
 
Thanks! I am trying to round up. In the first example I gave I should
have wrote 49,700. Sorry fo r the confusion. I am going to ry your
suggestions.

Thanks again to all fo the help.





On Sep 27, 11:07 am, JE McGimpsey wrote:
Hmm...

(1) What rounding rules are you proposing? Your first example rounds
DOWN, your third example rounds UP.

(2) With that, your example rounds to hundred thousands, not thousands -
there's no way to do that just with formatting. You can round to the
closest 100,000 with:

=ROUND(A1,-5)

To round just the display to *thousands*:

Format/Cells/Number/Custom #,##0,

In article . com,



wrote:
Does anyone know of a way to round to thousands in excel with a custom
format. I am trying to round as follows:


If the number is 49,677,298.86 I want 49,600 to display
If the number is 3,037,136.67 I want 3,000 to display
If hte number is 2,369,098.33 I want 2,400 to display


Thanks for your help.- Hide quoted text -


- Show quoted text -




ShaneDevenshire

Rounding to thousands in excel
 
Thanks JE,

I missed that.

--
Cheers,
Shane Devenshire


"JE McGimpsey" wrote:

Hmm...

(1) What rounding rules are you proposing? Your first example rounds
DOWN, your third example rounds UP.

(2) With that, your example rounds to hundred thousands, not thousands -
there's no way to do that just with formatting. You can round to the
closest 100,000 with:

=ROUND(A1,-5)


To round just the display to *thousands*:

Format/Cells/Number/Custom #,##0,

In article . com,
wrote:

Does anyone know of a way to round to thousands in excel with a custom
format. I am trying to round as follows:

If the number is 49,677,298.86 I want 49,600 to display
If the number is 3,037,136.67 I want 3,000 to display
If hte number is 2,369,098.33 I want 2,400 to display

Thanks for your help.




All times are GMT +1. The time now is 02:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com