% merges into word document in scientific format.

[K Mascolll]

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

 

[Doug Robbins - Word MVP]

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