Cancatenate

[triple_juicy]

This is the story: I put the text in cell A1,B1,C1. In B1 is th
result of a formula formated in currency but once cancatenated, th
formatting does not follow. Meaning instead of 0.00, I get 0.

Does anyone have any idea on how to get the number format included i
the cancatenation?

Thanks in advance and yes, I am always interested to learn especiall
technology

 

[Kevin Stecyk]

Triple,

A1 Kevin has
B1 in his pocket
C1 $5.20

A3 =A1&" " &TEXT(C1,"$0.00")&" " &B1

Result: Kevin has $5.20 in his pocket.

I think you want text(b1,"0.00")

Hope that helps.

Regards,
Kevin

 

[James S]

Try using the following:

TEXT(B1,"$0.00") or TEXT(B1,"0.00")

The whole formula would be:

=CONCATENATE(A1," ",TEXT(B1,"$0.00")," ",C1)

Hope that helps.

Regards,
James S

 

[triple_juicy]

I have not tried it yet but I am sure it will work because everybody is
saying the same thing.

Thanks very much and the world is a better place with the internet.
Lots of information at hand.

 

[George Nicholson]

Look at the TEXT worksheet function.
=TEXT(100,"000.00") would return 100.00 as text.

so
=A1 & " " & TEXT(B1,"000.00") & " " & C1
or
=CONCATENATE(A1," ",TEXT(B1,"000.00")," ",C1)
should give you what you are looking for.

Hope this helps,

 

[triple_juicy]

I have tried it now and it worked. Thank you all.