Re: Rounding to thousands in excel
- From: JE McGimpsey <jemcgimpsey@xxxxxxxx>
- Date: Thu, 27 Sep 2007 09:07:46 -0600
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 <1190902330.300909.94920@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
bridgetv@xxxxxxxxx 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.
- Follow-Ups:
- Re: Rounding to thousands in excel
- From: bridgetv
- Re: Rounding to thousands in excel
- References:
- Rounding to thousands in excel
- From: bridgetv
- Rounding to thousands in excel
- Prev by Date: Re: convert number to text without losing zeroes
- Next by Date: Re: convert number to text without losing zeroes
- Previous by thread: Rounding to thousands in excel
- Next by thread: Re: Rounding to thousands in excel
- Index(es):
Relevant Pages
|
