T
TCK
This is in two parts:
I am trying to make a simple invoice sheet in outlook custom forms 2003, you
know, quantity times unit price equals line price, then add up the line
prices to get a total at the bottom.
1. When I multiply the quantity and unit price, the resultant line total
field displays as plain numbers (or even text). I'd like to format them as
currency with the commas.
2. When I try to add this column of formula fields (line totals), for
example, instead of properly adding 33 and 66 to get 99, combines the two
numbers and displays 3366.
Help!
I am trying to make a simple invoice sheet in outlook custom forms 2003, you
know, quantity times unit price equals line price, then add up the line
prices to get a total at the bottom.
1. When I multiply the quantity and unit price, the resultant line total
field displays as plain numbers (or even text). I'd like to format them as
currency with the commas.
2. When I try to add this column of formula fields (line totals), for
example, instead of properly adding 33 and 66 to get 99, combines the two
numbers and displays 3366.
Help!