If you enter a number, say 1.2345 and set the display to two place of decimal
then it will be stored as 1.2345 but displayed as 1.24.

You can either convert the numbers to text before merging or specify the
desired format in the merge field.

"Janet(puzzle~~)" wrote:

I have a data source on in Excel with a few columns of figures. The decimal
place in the data source file is set to "2" but while it merged to the main
documents, the decimal place for the figure shown on the documents is "9".
E.g. in data file - 1,656.16
while it merged into main document: 1625.1600000000001

In the mergefield you wan to format... just add \#0.00 after the field code

For example to format Salary field change the field from
{MERGEFIELD "Salary" }
to
{MERGEFIELD "Salary" \#0.00}

See http://support.microsoft.com/kb/304387 for details.

------------------
Click 'Yes' if this solved your problem.


"Janet(puzzle~~)" wrote:

Thanks for your reply. Actually I have tried to convert the figure format
into "General" or "Text" before merged into main document. But it seems to be
the same. Or, may I know how to format the decimal place of merge cell in
words.

"Sheeloo" wrote:

If you enter a number, say 1.2345 and set the display to two place of decimal
then it will be stored as 1.2345 but displayed as 1.24.

You can either convert the numbers to text before merging or specify the
desired format in the merge field.

"Janet(puzzle~~)" wrote:

I have a data source on in Excel with a few columns of figures. The decimal
place in the data source file is set to "2" but while it merged to the main
documents, the decimal place for the figure shown on the documents is "9".
E.g. in data file - 1,656.16
while it merged into main document: 1625.1600000000001