Concatenate format

[Guest]

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!

 

[Guest]

=round(a1,1)&" - " &round(a2,1)&" - " &round(a3,1)

Cheers

Darren

 

[Guest]

Tom,

Format the offending 50.0 as text and then concatenate.

=A1&" - "&A2&" - "&A3

Mike

 

[Guest]

Thanks for the reply, however, this still omits the zero if it is after the
decimal place. I get 50 - 50.1 - 50.2 using what you provided. Any other
suggestions?

 

[Roger Govier]

Hi Tom

Try
=TEXT(A1,"#.0")&" - "&TEXT(A2,"#.0")&" - "&TEXT(A3,"#.0")

 

[Bob Phillips]

=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)