Hi Tobey,

=TEXT(Q2,"0.00")&" "&TEXT(R2,"0.00")&" etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Tobey" wrote in message ...
| Hi,
|
| I am trying to take quantity and price from 5 columns and merge them
| into one cell:
| From Columns Q-U:
| 67.40 3 192.96 5 288.85
|
| To Column V:
| 67.4 3 192.96 5 288.85
|
| However, I keep losing my two decimal places in #s like 67.40!
| I used the function:
| =Q2&" "&R2&" "&S2&" "&T2&" "&U2
|
| How do I retain the two decimal places in my last column?
|
| Thank you so much!
|
|