Rounding to thousands in excel

[bridgetv]

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.

 

[Guest]

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)

 

[JE McGimpsey]

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,

 

[bridgetv]

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.

 

[Guest]

Thanks JE,

I missed that.

 

[hclamp]

The formula you want to use in format cells -> custom -> type is $#,#00,