Thread: Preserve format of data in Excel when doing a mail merge
View Single Post
  #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
Reply With QuoteReply With Quote