Decimal Points
 

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

Decimal Points
 

Check out ToolsOptionsFixed Decimal Places

--
__________________________________
HTH

Bob

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

Decimal Points
 

assume a1 = 123
enter d1 = a1/100

This will make d1 = 1.23
--
Wag more, bark less


"Jim Wyns" wrote:

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