How the increase decimal operation is performed in Excel and how they done it?

**Case 1 :**

I enter a number in a cell whose number of digit is less than 11.

For instance A1 cell value be : **123**

If I perform 2 times increase decimal operation then value be : **123.00**

For every increase decimal operation an additional 0 is appended to the digit in decimal place.

**Case2:**

If I enter number greater than 11 it becomes exponent form

For instance I enter 123456789012(greater than 11 digits) the value get changed to exponent form as **1.23457E+11**

If I perform increase decimal operation 1 time then value be **1.234568E+11**

While performing increase decimal the exponent value is not increased but the digits I entered initially are displaying one by one.

My doubt is

**1.23457E+11 * 10** ie. (Intial value when i entered digits > 11) * (Since I increase by one decimal)

So the result should be **1.23457E+12**. Exponent number should be increased as

(1.23457*10pow11) * 10pow1 so result shoud be 1.23457*10pow12 but the value in the cell is **1.234568E+11**

I have the same doubt in Decrease decimal too.

Please help me on this.. I want to understand it clearly, So help me guys.

By: Keerthi vasan A