mail merge

[lishman]

iam trying to mail merge an excel file of peoples salaries. When the numbers are presented in word values are trimmed, eg £1000.50 is shown in mail merge as £1000.5
How do I format the number cells in excel so that the number shown is in the correct format.

 

[iliace]

In the Word document, add to the field code a switch for formatting, i.e. if the code is:

{ MERGEFIELD Value }

add \# "£0.00" so that it looks like

{ MERGEFIELD Value \# "£0.00" }

that will format the raw Excel data in Word.

 

[lishman]

Many thanks. a lot simpler solution to the one a devised by testing character lens then converting value to text based on expected character len( it works but very cumbersome!!)