How does Increase decimal and Decrease decimal work in Excel

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.




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

Leave a Reply

Your email address will not be published. Required fields are marked *