ExcelBanter - Formating decimal numbers

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formating decimal numbers (https://www.excelbanter.com/excel-discussion-misc-queries/82660-formating-decimal-numbers.html)

Rafael

Formating decimal numbers

I'm trying to format the decimal numbers to show a result of a calculation
formula, variating from 0,2 to 0,2 only.

CLR

Formating decimal numbers

Maybe this will help.......

=MROUND(A1,0.2)

Vaya con Dios,
Chuck, CABGx3

"Rafael" wrote:

I'm trying to format the decimal numbers to show a result of a calculation
formula, variating from 0,2 to 0,2 only.

All times are GMT +1. The time now is 03:55 PM.