Go to FromatCellsCustom. In the type box, put ### "sq ft". The ### are
placeholders for numbers. So the data entered into the cell will calculate
and place sq ft as a display or format. The sq ft is for display or
presentation/printing.
Hope this helps.
Pat

"construction_secretary" wrote:

How can I format the cell to hold the amt to calculated with the measurement
unit in the same cell?

i.e. b27 needs to read 158 sq ft c27 is $ amt ($0.17) d27 is the formula

=(b27*c27)

When I enter in just the number 158 it calculates in d27 correctly, but when
I add sq ft after 158, d27 shows an error message #VALUE!

Thank you!