Decimal Points

[Jim Wyns]

I want to input 123 and have it print 1.23 in certain cells and columns. How
do I do this?
Thanks

 

[Bob Phillips]

Check out Tools>Options>Fixed Decimal Places

 

[Brad]

assume a1 = 123
enter d1 = a1/100

This will make d1 = 1.23