![]() |
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. |
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. |
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. |
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 - |
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 07:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com