Catalog Merge losing my trailing zeros

G

Gloria Lewis

I'm doing a catalog merge using Publisher 2003 w/Access 2003 as my data
source. How can I get publisher to retain my trailing zeros in my prices.
This is what my data looks like in Access:
ItemNum Description Description2 Unit Sell PicturePath
FL-3299 LADIES MICRO PIMA OXFORD (Add $1.00 for XXL) $24.30 H:\FL-3299.jpg
FL-3300 DIVOT TOOL $8.60 H:\FL-3300.jpg
FL-3301 POLYBCARB WATER BOTTLE $3.80 H:\FL-3301.jpg
FL-3302 MEN'S DROP NEEDLE MOCK (Add $1.00 for XXL) $35.95 H:\FL-3302.jpg

The Unit Sell is defined as currency. I've tried currency, number and fixed
all with the same result.

After merging, any items with the price ending in zero, drops the zero is my
price comes out as $8.6 instead of $8.60. Help.
 
Top