Formatting Numbers Help

  • Thread starter Thread starter Craig M
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula for decimal point 4
Sum number range ignoring numbers formatted as text 0
How to set cell value to emptry if three other columns are empty too 1
format 9
Counting Cells with Conditional Formatting 7
Automatically chnage number format of a range of cells 2
Array Summation in Excel 0
help with auto sum 4

Back
Top