Formatting formula Fields

[Guest]

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!

 

[Sue Mosher [MVP-Outlook]]

1) Try using the CCur() function, under Conversion. If that doesn't work,
you can use the Format() function. Look up its syntax in VBA help.

2) Use the appropriate conversion function for your data to convert each
term into a number.