Mail Merge Issue!

**carlosbourn** · 06-30-2007, 07:40 AM

I'm trying to sort a mail-merge out importing figures from an xls to word but for some reason the figures are showing lots and lots of decimal points upon merging. Thus ruining the word doc.

The format in the xls is number and set to 2 decimal points. When you click on an individual cell, it shows numerous decimal points in the formula bar where I'm assuming is what the merge function is picking up.

I tried manually overtyping each cell to 2 decimal figures but still made them massively decimal-pointyised!

Is there any way I can 'convert' the data with lots of decimal points to 2 decimal points? This is most frustrating!

Thanks in anticipation :o)

See link below for posted picture...

Click Here!

**carlosbourn** · 06-30-2007, 08:36 AM

Right - I've figured out how to amend the 'Field Code' in MS Word to show...

{ MERGEFIELD "Hull" \# "0.00" }

By inserting "0.00" it restricts the numerical format to 2 decimal points. Woo!

However, does anyone know what sort of format would I have to apply to insert a comma after every thousand? i.e. 207,354.78

Thanks!

**Teethless mama** · 06-30-2007, 10:19 AM

Originally Posted by carlosbourn

Right - I've figured out how to amend the 'Field Code' in MS Word to show...

{ MERGEFIELD "Hull" \# "0.00" }

By inserting "0.00" it restricts the numerical format to 2 decimal points. Woo!

However, does anyone know what sort of format would I have to apply to insert a comma after every thousand? i.e. 207,354.78

Thanks!

=(1-LOOKUP(C1,{"A","B","C"},{0,0.1,0.15}))*D1

**VBA Noob** · 06-30-2007, 12:37 PM

Thread closed for cross posting. Please read forum rules below. If you agree to them then PM me and I will unlock the thread

VBA Noob

Mail Merge Issue!

LinkBack

Thread Tools

Display

Mail Merge Issue!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions