Formatting cells

  • Thread starter Christopher Anderson
  • Start date
C

Christopher Anderson

Something has happened with my cells that has whacked the formatting.

I have entered =(sum(E5:W5)/5280)&" ft."

It gives me the correct answer but I have 10 too many zeroes after my
decimal place. How do I format the cell so that I only have three decimal
places???

CHRIS
 
B

Bob Phillips

Chris,

Myrna missed a quote before the ft., but you could also use

=TEXT(SUM(E5:W5)/5280,"0.000 ft.")
 
D

Debra Dalgleish

You could change the formula to: =SUM(E5:W5)/5280
Then, select the cell, and choose Format>Cells
Select the Number tab
Select the Custom category
In the text box, type: 0.00 ft
Click OK
 
Top