format cells for Currency in catalog merge

[Randall Arnold]

I've created a single page publisher document that is intended to display
prices of a certain vendor's items. To do this, I merged several fields
from an Access query into the document and filtered the records I wanted.
This worked fine (for the most part). However, Access formatting was not
carried into the document, and my currency valuesa re not recognizable as
such. I can't find anything in Help that describes how to format a table
cell for currency values.

Any ideas?

Thanks,

Randall Arnold

 

[°°°M°S°°Publisher°°°]

Export your data from Access into a CSV (Comma Separated Values) and use the
CSV file for your merge database file.

--

 

[Randall Arnold]

Thanks for the suggestion, but I'm trying to use one master database to
store all product data and repurpose it automatically in various media. The
whole idea is to get away from importing and exporting and cutting and
pasting (etc etc etc). Anytime the source data is updated I want all
end-use documents to be updated as well without human intervention.

I'm curious, though: how will using a CSV file as the data source allow
Publisher to properly represent currency types? The shortcoming appears to
be in Publisher's inability to fully format cells as far as I can see.

Randall Arnold

 

[°°°M°S°°Publisher°°°]

The Merge feature in Publisher is very basic, and consequently why there is
the need to use a CSV file in many cases.

--

 

[Randall Arnold]

The CSV file does not ipso facto render currency values into a Publisher
table cell. The data source does not necessarily control the format of the
output. I think you're misunderstanding my question.

Randall Arnold

 

[°°°M°S°°Publisher°°°]

Just put the $ sign in Publisher.
I do understand your question as I am fully aware of the limitation of the
Publisher merge. It will not allow, or I should say, does not understand
cell formatting.

--

 

[°°°M°S°°Publisher°°°]

If you copy the information in your application and choose to paste VALUES
only to a new column/field, you will have the correct formatting with $
signs you require.

You are correct, it is a pain in the butt. It is no different to MS not
supporting other companies import database formats.

--