Formatting Numbers Help

Giganews Newsgroups
Subject: Formatting Numbers Help
Posted by:  Craig M (le…@shaw.ca)
Date: Tue, 16 Jan 2007

Hi there!

Is it possible to type 1210 into a cell and have it formatted with a decimal
automatically placed to make it 12.10. If so is it possible to have it
summed in another cell to  =Sum(A1:A3)  in which you have 1210 entered in
all three cells... the total would be 3630 formatted as 36.30  Is this
possible?

Thanks
Craig

Replies