merging text and data fields without loosing zeroes ie .00l
replace the # with 0
"Bricap" wrote:
How do I merge text and data fields without loosing zeroes to the right of
the decimal point? .00
I'm using the following 2 formulas to merge more that one field into a new
merged field containing all the text and #'s from the individual fields.
=A1&" "& TEXT (B1,"$ #,##.##")&" "&C1 (this combines 3 fields)
or =Q13&""&H14&""&M14&""&G14&""&N14&""&O14&""&P14 (this compines 7 fields)
The problem I'm having is: One of the fields that I am grabbing is a number
field to 2 decimal place i.e. 12.50, but when I merge the fields together,
the number is truncated to 12.5 I do not want to loose my zeroes. even if
one of my original fields is 5.00.
|