How about

=CONCATENATE(TEXT(A1,"0.000")," inches")

or

=TEXT(A1,"0.000") & " inches"

"dbizek" wrote:

How can I get cell A1 to show trailing zeros?

I've entered =CONCATENATE(A1," inches")

When A1 equals 1.50 or .060 it displays 1.5 inches or .06 inches

I need those missing zeros!
THANKS