Yes that did help, thank you very much. But what if the measurement changes?
If I set b27 at Sq Ft for one customer, then the next file that I am using
the worksheet on, b27 may be linear feet. Is there a way to customize the
cell to enter the number then the measurement unit without having to format
the cell everytime?

"Pat Flynn" wrote:

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!