[MSalant]

Using Office 2007, when I do a mail merge using Excel as the data source. The
numbers I have in the spread sheet with $ signs or decimial points in Excel
are removed once the merge is complete in Word. Is there as setting I can use
to ensure that formatting is retained? For ex.... $15.00 will merge into
the doc as 15

HELP!!!

Thanks
Mike

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"MSalant" wrote in message
...
Using Office 2007, when I do a mail merge using Excel as the data source.
The
numbers I have in the spread sheet with $ signs or decimial points in
Excel
are removed once the merge is complete in Word. Is there as setting I can
use
to ensure that formatting is retained? For ex.... $15.00 will merge into
the doc as 15

HELP!!!

Thanks
Mike

[MSalant]

Doug........Thanks!!!!!!!!!!!!

"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"MSalant" wrote in message
...
Using Office 2007, when I do a mail merge using Excel as the data source.
The
numbers I have in the spread sheet with $ signs or decimial points in
Excel
are removed once the merge is complete in Word. Is there as setting I can
use
to ensure that formatting is retained? For ex.... $15.00 will merge into
the doc as 15

HELP!!!

Thanks
Mike