can I make calculations in MS Excel with cells having the Feet (') & (") symbols with them.?

2 ⤊

can I make calculations in MS Excel with cells having the Feet (') & (") symbols with them.?

eg... 5'6" x 3'4" and not it's decimal format as 5.5 x 3.33..

2006-10-09 16:18:56 · 3 answers · asked by genecon 2 in Computers & Internet ➔ Programming & Design

3 answers

Here's what I would do. Store the feet and inches in their own columns (say A and B). Then in C, put this formula: =CONCATENATE(A1,"'",B1, "''")

That will format 5' 6''. You can do the same for the X and the other side of the equation. Then, if you only want to see the result, you can hide the A and B columns and only see the 5'6.

2006-10-09 16:34:33 · answer #1 · answered by SDLifeCycle 2 · 1⤊ 0⤋

Format ... Cells ... Choose Fractions... Choose sixteenths Which is probably the best for measuring.

2006-10-09 23:55:05 · answer #2 · answered by Kevin 4 · 1⤊ 0⤋

I don't know. Simplest way to find out is to try it.

2006-10-09 23:21:09 · answer #3 · answered by bob h 5 · 0⤊ 1⤋