Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to retain decimal zeroes? | Excel Discussion (Misc queries) | |||
function or format - remove decimal but retain value | Excel Programming | |||
Decimal Places | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |