Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
jay jay is offline
external usenet poster
 
Posts: 79
Default Number Format in Mailmerge

I am creating an information catalog in mailmerge using data from an Excel
file. The numbers are formatted w/ commas, % signs, etc. in Excel, but come
into Word w/o this formatting. I need the commas, % signs, etc., though. Is
there a way to preserve the formatting in Excel or apply formatting in the
mailmerge process? Thx, J
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Number Format in Mailmerge

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

"Jay" wrote in message
...
I am creating an information catalog in mailmerge using data from an Excel
file. The numbers are formatted w/ commas, % signs, etc. in Excel, but
come
into Word w/o this formatting. I need the commas, % signs, etc., though.
Is
there a way to preserve the formatting in Excel or apply formatting in the
mailmerge process? Thx, J



Reply
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
Mailmerge and number format yshridhar Mailmerge 3 November 6th 07 09:16 AM
Mailmerge Display as Social Security Number Format Dave Mailmerge 1 September 28th 07 01:09 AM
Mailmerge number formatting KC8DCN Mailmerge 1 May 24th 06 04:43 AM
How do I make an automatic number small caps under Number Format? grebop Microsoft Word Help 3 October 17th 05 05:31 AM
Loosing SSN number format after mailmerge Lisa Mailmerge 2 February 17th 05 03:15 PM


All times are GMT +1. The time now is 12:53 AM.

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"