How to merge numerical values of an excel file into a DOC with a limited number of decimals after the point

Switzernet

2008-03-04

This DOC is merged with an excel fie ‘input.xls’

Merge Record Number is: 1

The current value is: 90.909090909090907

The current value rounded is:   90.91

The first value shows plenty of digits after the decimal point. The value is inserted into the DOC file using the standard Insert Merge Field panel:

A solution is to use the =FIXED() function in excel to replace the digital values with safe text values. However this solutions handicaps the excel file for further use of values:

The second value of this DOC is rounded to display only two positions after the decimal point. This value is inserted differently.

Use [Insert] è [Field…] menu command:

Then choose Formula:

Type in the Formula filed mergefield “values” (where “values” is the name of the corresponding field in your excel file).  In the drop-down menu choose the desired number display format:

Download:

The input excel file [xls]

The merge DOC file [doc]

The merged output doc file [doc]

The web format [htm]

*   *   *

How to merge numerical values of an excel file into a DOC with a limited number of decimals after the point

Switzernet

2008-03-04

This DOC is merged with an excel fie ‘input.xls’

Merge Record Number is: 2

The current value is: 83.333333333333329

The current value rounded is:   83.33

The first value shows plenty of digits after the decimal point. The value is inserted into the DOC file using the standard Insert Merge Field panel:

A solution is to use the =FIXED() function in excel to replace the digital values with safe text values. However this solutions handicaps the excel file for further use of values:

The second value of this DOC is rounded to display only two positions after the decimal point. This value is inserted differently.

Use [Insert] è [Field…] menu command:

Then choose Formula:

Type in the Formula filed mergefield “values” (where “values” is the name of the corresponding field in your excel file).  In the drop-down menu choose the desired number display format:

Download:

The input excel file [xls]

The merge DOC file [doc]

The merged output doc file [doc]

The web format [htm]

*   *   *

How to merge numerical values of an excel file into a DOC with a limited number of decimals after the point

Switzernet

2008-03-04

This DOC is merged with an excel fie ‘input.xls’

Merge Record Number is: 3

The current value is: 76.92307692307692

The current value rounded is:   76.92

The first value shows plenty of digits after the decimal point. The value is inserted into the DOC file using the standard Insert Merge Field panel:

A solution is to use the =FIXED() function in excel to replace the digital values with safe text values. However this solutions handicaps the excel file for further use of values:

The second value of this DOC is rounded to display only two positions after the decimal point. This value is inserted differently.

Use [Insert] è [Field…] menu command:

Then choose Formula:

Type in the Formula filed mergefield “values” (where “values” is the name of the corresponding field in your excel file).  In the drop-down menu choose the desired number display format:

Download:

The input excel file [xls]

The merge DOC file [doc]

The merged output doc file [doc]

The web format [htm]

*   *   *

How to merge numerical values of an excel file into a DOC with a limited number of decimals after the point

Switzernet

2008-03-04

This DOC is merged with an excel fie ‘input.xls’

Merge Record Number is: 4

The current value is: 71.428571428571431

The current value rounded is:   71.43

The first value shows plenty of digits after the decimal point. The value is inserted into the DOC file using the standard Insert Merge Field panel:

A solution is to use the =FIXED() function in excel to replace the digital values with safe text values. However this solutions handicaps the excel file for further use of values:

The second value of this DOC is rounded to display only two positions after the decimal point. This value is inserted differently.

Use [Insert] è [Field…] menu command:

Then choose Formula:

Type in the Formula filed mergefield “values” (where “values” is the name of the corresponding field in your excel file).  In the drop-down menu choose the desired number display format:

Download:

The input excel file [xls]

The merge DOC file [doc]

The merged output doc file [doc]

The web format [htm]

*   *   *

How to merge numerical values of an excel file into a DOC with a limited number of decimals after the point

Switzernet

2008-03-04

This DOC is merged with an excel fie ‘input.xls’

Merge Record Number is: 5

The current value is: 66.666666666666671

The current value rounded is:   66.67

The first value shows plenty of digits after the decimal point. The value is inserted into the DOC file using the standard Insert Merge Field panel:

A solution is to use the =FIXED() function in excel to replace the digital values with safe text values. However this solutions handicaps the excel file for further use of values:

The second value of this DOC is rounded to display only two positions after the decimal point. This value is inserted differently.

Use [Insert] è [Field…] menu command:

Then choose Formula:

Type in the Formula filed mergefield “values” (where “values” is the name of the corresponding field in your excel file).  In the drop-down menu choose the desired number display format:

Download:

The input excel file [xls]

The merge DOC file [doc]

The merged output doc file [doc]

The web format [htm]

*   *   *