Instead of using number formats, use text functions. Something like =concatenate(text(formula,"0.0")," ft")