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!