May 20, 2008

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

2 comments:

Srivatsa said...

srivatsayngrthanks

Anonymous said...

Thanks Heaps