Publisher 2003 catalog merge Dollar field problem trailing zeros

[FrankSpokane]

I am doing a merge from an access 2003 mdb into publisher, and there is one
numeric field - a dollar field - which loses decimal zeros on the catalog
merge.

The zeros show up in the access table - the field is a numeric field with a
currency format, but Publisher is dropping zeros after the decimal point
thusly:

$ 25.00 comes in as 25 (no decimal point)
$ 25.50 comes in as 25.5 (decimal point but no last zero)
$ 25.55 comes in ok as 25.55

TIA for solution to this problem.

 

[Mary Sauer]

Define the field as text.
How many decimal points have you selected in the regional options in the control
panel?

 

[FrankSpokane]

I can't define the field as text in Access because it is the price of the
product, and I have many reports that need to do various sums and
calculations of this field. My regional options are set for .00 for numbers
and currency.

 

[Mary Sauer]

A text field will remain exactly as you typed it, it matters not if it is a number.
Might read this article, it addresses Excel, but it is the same with Access.
Answer Box: Numbers don't merge right in Publisher
http://office.microsoft.com/en-us/assistance/HA011165801033.aspx