View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tobey Tobey is offline
external usenet poster
 
Posts: 3
Default Retain decimal places in a concatenate function

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!