Friday 27 May 2011

Excel automatically change decimal places


Problem: When number is entered in excel, it is automatically divided by 100


For example, number 25 shows up as 0.25


Tools - Options - Edit


Uncheck Fixed decimal places

No comments:

Post a Comment