ExcelBanter - Automatic divided by 100000

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

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

- - Automatic divided by 100000 (https://www.excelbanter.com/excel-discussion-misc-queries/26554-automatic-divided-100000-a.html)

Gian

Automatic divided by 100000

Hi all,

On a new worksheet, when I type in a number in the cell, right after I hit
"Enter", it automatic divide the number by 100,000, why this happened?
Please help.

Thanks.

Gian

Peo Sjoblom

Toolsoptionsedit and uncheck fixed decimal places

Regards,

Peo Sjoblom

"Gian" wrote:

Hi all,

On a new worksheet, when I type in a number in the cell, right after I hit
"Enter", it automatic divide the number by 100,000, why this happened?
Please help.

Thanks.

Gian

Gian

Thanks.

"Peo Sjoblom" wrote:

Toolsoptionsedit and uncheck fixed decimal places

Regards,

Peo Sjoblom

"Gian" wrote:

Hi all,

On a new worksheet, when I type in a number in the cell, right after I hit
"Enter", it automatic divide the number by 100,000, why this happened?
Please help.

Thanks.

Gian

All times are GMT +1. The time now is 11:38 PM.