=TEXT(A1,"0.0 - ")&TEXT(A2,"0.0 - ")&TEXT(A3,"0.0")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Tom" wrote in message
...
Can someone suggets how to concatenate
50.0 50.1 50.2
into
50.0 - 50.1 - 50.2
That is the number (with one decimal place) followed by a SPACE HYPHEN
SPACE
second number with one decimal place...etc
Everything I try omits the ".0" if it happens to be a zero. I also have
some
cells that require 2 decimal places and may end in two zeros....I would
like
those to have the same format....number space hyphen space number.

Thanks!