ExcelBanter - Automatic rounding of number

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

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

- - Automatic rounding of number (https://www.excelbanter.com/excel-discussion-misc-queries/142156-automatic-rounding-number.html)

MaurÃcio

Automatic rounding of number

I type a number (in Excel), for example, 2 and appears 0,02. Why?

Toppers

Automatic rounding of number

Tools=Options=Edit=Uncheck Fixed Decimal places

"MaurÃ*cio" wrote:

I type a number (in Excel), for example, 2 and appears 0,02. Why?

All times are GMT +1. The time now is 02:05 PM.