ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   using round to increase decimal ? (https://www.excelbanter.com/excel-programming/310651-re-using-round-increase-decimal.html)

Ron Rosenfeld

using round to increase decimal ?
 
On Mon, 20 Sep 2004 14:51:03 -0700, "rania"
wrote:

fhi

I would like to increase decimal using round function instead of Format .
for example Ihave 422, and would like 422.00 to be schown.

I know that it does not make since because of the function of round.
but I have this in an excercice .

Thanks


The ROUND function cannot cause 422 to be displayed as 422.00

It could turn 422.004763 into 422.00


--ron


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

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