Formatting cells

[Guest]

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

 

[Myrna Larson]

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

 

[Bob Phillips]

Chris,

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

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

 

[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