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