Formatting Loss - Dollar and Date

[Christine]

Before upgrading to XP, I didn't have to manually change the formatting for dollars and dates after a merge from an Excel datafile into a Word Document. The Formula Bar in Excel doesn't reflect the formatting - only the true value, which is what now appears in my Word file. How can I preserve the formatting in XP?

 

[Doug Robbins - Word MVP]

Hi Christine,

See the following page on fellow MVP Graham Mayor's website

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

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

Before upgrading to XP, I didn't have to manually change the formatting

for dollars and dates after a merge from an Excel datafile into a Word
Document. The Formula Bar in Excel doesn't reflect the formatting - only
the true value, which is what now appears in my Word file. How can I
preserve the formatting in XP?