[Nat]

I have a Word 03 document that is merging data from an Excel 03 spreadsheet,
and even though the data is formatted as currency ($#,###.00) when it is
inserted into the Word merge document it has no formatting. Do I have to
format the merge field in the Word document, and if so does anyone know how?
This is being done using Word & Excel 07 BTW.

Thanks a lot,

[CyberTaz]

Short Story: The formatting in Excel is exactly that - *formatting* - which
is a property of the cell, not literal characters in the data.

Long Story: http://word.mvps.org/faqs/MailMerge/index.htm
--
HTH |:)
Bob Jones
[MVP] Office:Mac

"Nat" wrote in message
...
I have a Word 03 document that is merging data from an Excel 03
spreadsheet,
and even though the data is formatted as currency ($#,###.00) when it is
inserted into the Word merge document it has no formatting. Do I have to
format the merge field in the Word document, and if so does anyone know
how?
This is being done using Word & Excel 07 BTW.

Thanks a lot,

[Graham Mayor]

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Nat wrote:
I have a Word 03 document that is merging data from an Excel 03
spreadsheet, and even though the data is formatted as currency
($#,###.00) when it is inserted into the Word merge document it has
no formatting. Do I have to format the merge field in the Word
document, and if so does anyone know how? This is being done using
Word & Excel 07 BTW.

Thanks a lot,

[Nat]

Thanks so much Graham. this was helpful as it provides 2 solutions: Either
format with switch, or choose the way Word communicates with XLS data source.
I have chosen the former, however I could not get the \# ",0.00" to work for
some reason so I tweaked it slightly. My solutions was to add the following
switch [\ # #,##0.00.

Not sure why it works but it does. Thanks again,

Nat

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Nat wrote:
I have a Word 03 document that is merging data from an Excel 03
spreadsheet, and even though the data is formatted as currency
($#,###.00) when it is inserted into the Word merge document it has
no formatting. Do I have to format the merge field in the Word
document, and if so does anyone know how? This is being done using
Word & Excel 07 BTW.

Thanks a lot,

[Graham Mayor]

More curious is why the original switch didn't work, my guess would be smart
quotes in the field construction, but yours should do the job.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Nat wrote:
Thanks so much Graham. this was helpful as it provides 2 solutions:
Either format with switch, or choose the way Word communicates with
XLS data source. I have chosen the former, however I could not get
the \# ",0.00" to work for some reason so I tweaked it slightly. My
solutions was to add the following switch [\ # #,##0.00.

Not sure why it works but it does. Thanks again,

Nat

"Graham Mayor" wrote:

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Nat wrote:
I have a Word 03 document that is merging data from an Excel 03
spreadsheet, and even though the data is formatted as currency
($#,###.00) when it is inserted into the Word merge document it has
no formatting. Do I have to format the merge field in the Word
document, and if so does anyone know how? This is being done using
Word & Excel 07 BTW.

Thanks a lot,