ExcelBanter - Decimal Places

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Decimal Places (https://www.excelbanter.com/excel-programming/377742-decimal-places.html)

Sundara Murthy

Decimal Places

Hello Experts,

I am entrying the numberic value 55555 result will be displaying like 555.55
how to avoid this?

Any setting will be changed?

regards,
Sundara Murthy.S

Bob Phillips

Decimal Places

Goto ToolsOptions and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Sundara Murthy" wrote in message
...
Hello Experts,

I am entrying the numberic value 55555 result will be displaying like
555.55
how to avoid this?

Any setting will be changed?

regards,
Sundara Murthy.S

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