That works, thanks! How about this? Is there a way to contol the number of
decimal places in that string? IE if its 1.500 i'd like to show 1.50 but if
it's .060 i'd like to show .060 any ideas?

"Barb R." wrote:

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