[HELP ME] Excel to Word 2003 Field Formatting Issues

[mrcif]

Hi everyone,

I've got a big problem with data source from Excel sheet, using ROUND function.

My number in Excel is: 6,4000000000000004
by using ROUND with 2 decimal, result: 6,40.

But when I make a mail merge, the result always show: 6,4000000000000004 (I expected its show: 6,40 in Word 2003 letter)

I've try many times, with this: {MERGEFIELD Field_Name \# #.00}

but no result.

Pls help me to solve this problem. I'm get the stuck now. Thanks for your helping. Pls reply me as soon as possible.

Thanks a lot.

Viet, Bui Quoc.

 

[Cindy Ellis]

Hello, and Welcome to the forum.

I was able to reproduce your problem, and have a potential solution, although it may or may not work for your particular situation.

The only workaround I could find was to convert it to text in Excel, before pulling it in with the mail merge. With the problematic data in column A, I used the function (in cell D2, to allow for other data columns)

=text(A2,"0.00")

You would then drag it down to all rows, and use that column as the input column for Word's mail merge.
You will need to adjust the decimal and argument delimiters for your location...we use "." as the decimal separator, and "," as the argument delimiter for my location settings. Based on the info in your question, I think it will be different for you, but the concept is the same.
Hope that helps,
Cindy

 

[mrcif]

Thanks for your replying, Cindy.

but in Excel, i've formatted all of values in columm in text (via Format Cell... Text format).

The result: 6,4000000000000004 (in Word)

Have you got any way to solve this problem?Thanks a lot.

 

[Cindy Ellis]

Please read my reply carefully.
I solved the problem by actually converting the data to text in excel, not just formatting it as text, by using the "TEXT()" formula.
Nothing else that I tried solved the problem.
Regards,
Cindy

 

[meldoc]

Hello

Maybe this will help.

http://office.microsoft.com/en-us/w...rs-don-t-merge-right-in-word-HA001116495.aspx

 

[tweedle]

I think this is the field-format syntax:
MERGEFIELD BigNum \# "0.00" \* MERGEFORMAT
results in 6.40

 

[Cindy Ellis]

Thanks for stepping in Tweedle. I didn't even notice that the mergeformat keyword was missing from the original post...just copied/pasted the field codes in the original post, which of course, gave the same result.