Formatting Numbers Help

C

Craig M

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
 
B

Bernard Liengme

Using Tools | Options, opening the Edit tab and setting Fixed Decimal ON and
set to 2 you can enter 1210 and have 12.10 appear in the cell.

However, this will apply to ALL cells in all books that you open until you
reset the option

As for the SUM() questions, why not =SUM(A1:A3)*100

best wishes from Nova Scotia
 
Top