LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to retain decimal zeroes? Antony Excel Discussion (Misc queries) 5 September 8th 09 09:59 PM
function or format - remove decimal but retain value Geraldine Excel Programming 3 March 29th 08 12:16 AM
Decimal Places JHL Excel Discussion (Misc queries) 4 April 24th 07 06:44 PM
Subtracting two 2-decimal place numbers gives result 13-decimal places? [email protected] Excel Worksheet Functions 5 March 12th 07 10:38 PM
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. SUKYKITTY Excel Discussion (Misc queries) 3 July 6th 05 01:50 PM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"