Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Louise Louise is offline
external usenet poster
 
Posts: 9
Default Preserve format of data in Excel when doing a mail merge

I am using Office 2007 and am trying to do a mail merge using data from an
Excel spreadsheet. I have a 'Salary' field in Excel with the data formatted
in the £ currency style e.g. £30,000.00 but when I merge the data, I lose the
formatting. How can I keep the formatting in the same way as it is displayed
in Excel?
--
Thanks, Lou
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge and excel data sherobot Mailmerge 2 April 23rd 07 08:08 PM
Merge Excel Data into Word but NOT as a letter format? tough teacher Mailmerge 1 July 26th 06 08:46 PM
How do you preserve the data format from your data source when me. DOU Mailmerge 1 February 22nd 05 11:53 PM
Preserve a macro-table's format when fetching data thro' merge pro FayMit Tables 1 February 7th 05 11:11 AM
mail merge from excel that changes my format from UK to US format mark Mailmerge 0 January 21st 05 03:01 PM


All times are GMT +1. The time now is 01:32 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"