Concatenation / Format $ / Split Lines
Posted by Donna on August 07, 2001 12:44 PM
I would like to be able to take a column that I have concatenated with a description and two units with prices after and I would like to be able to print the description on one line and the units/prices on the next line. My other problem is that the prices will not format correctly (for instance $1.80 comes
out $1.8 with no zero).
I will try to show an example: but, right now I can get it all in one line but the zeros don't come out right
Abington $9.9/sqyd $1.1 /sqft
This is how I would like to format it for printing on lables:
Carpet Name (I would like this centered???)
$ 2.00 / sqft
$18.00 / sqyd
If possible, could you email me an answer? I don't know if I'll be able to get back here. Anyways, thanks for any help.