Mail Merge Issue (Word/Excel)

[fentocy]

I'm trying to merge data from an Excel worksheet into a Word document. The information in Excel was input using five numbers, decimal, six numbers, but the cells are formatted to display as a Number, 2 decimal places, comma separator. When I merge the Excel data into the Word letter, it comes in as the original formatting for the number (i.e., 55555.666666) instead of the desired formatting (i.e., 55,555.22). I'm not sure if I need to do some field code formatting in Word or something in Excel to force the data to merge with the proper formatting. Any help would be greatly appreciated. Thanks!

 

[xlbo]

Not sure you can do anything formatting wise in excel but if you are prepared to use a "helper" column, you may use:

=ROUND(A2,2)

and format as you desire where A2 is the 1st cell with the number in. This should resolve the "actual" data issue.

If you don't want it to round and you always have the same number of characters then

=VALUE(LEFT(A2,8))

should do the trick

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question

 

[DPlank]

Not to be picky or anything, but wouldn't the data change from 55555.666666 to 55,555.67 rather than to 55,555.22?

Just wondering if there is something else going on calculation wise, or if this is purely to show the differences in formatting.



Cheers,
Dave

Probably the only Test Analyst Manager on Tek-Tips...therefore whatever it was that went wrong, I'm to blame...

animadverto vos in Abyssus!

Take a look at Forum1393!

 

[fentocy]

Yes, the number would technically change to 55555.67, except I was trying to capture the number of digits before and after the decimal. Probably a bad idea on my part. Thanks!