Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
K Mascolll K Mascolll is offline
external usenet poster
 
Posts: 1
Default % merges into word document in scientific format.

Hi,

When I merge a field from excel to a letter in word it converts the cells, which are formatted as a % into scientific format. Is there a way to get the cells to show up as they should?

There is no formula on the cells. For example, 0.0016 is the data, formatted to a % it reads 0.16%

Thanks

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
  #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 % merges into word document in scientific format.

see
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

K Mascolll wrote in message ...
Hi,

When I merge a field from excel to a letter in word it converts the cells,
which are formatted as a % into scientific format. Is there a way to get
the cells to show up as they should?

There is no formula on the cells. For example, 0.0016 is the data,
formatted to a % it reads 0.16%

Thanks

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com



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
Scientific format GCNY Mailmerge 9 February 26th 07 11:06 AM
Insert table in word - don't convert to scientific notation BillM... Tables 2 November 2nd 06 08:26 PM
2 merges on 1 document JKarchner Mailmerge 3 August 25th 06 11:48 PM
Combine multiple merges into one document kaufmed Mailmerge 2 May 14th 06 11:16 AM
long scientific document Qreg Formatting Long Documents 11 April 19th 05 03:35 PM


All times are GMT +1. The time now is 03:59 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"