ExcelBanter - Rounding number within cell value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Rounding number within cell value (https://www.excelbanter.com/excel-worksheet-functions/225578-rounding-number-within-cell-value.html)

Bagia

Rounding number within cell value

Hello,

Is there a way to round values within a cell to display the values in
millions? For example, in A2 I have a value of 815,000,001 and would like to
display it as 815,000,000 in the same cell (A2).

Thanks

nibbana

Rounding number within cell value

=ROUND(A2,-5)

"Bagia" wrote:

Hello,

Is there a way to round values within a cell to display the values in
millions? For example, in A2 I have a value of 815,000,001 and would like to
display it as 815,000,000 in the same cell (A2).

Thanks

All times are GMT +1. The time now is 08:32 AM.