Reply
 
Thread Tools Display Modes
  #1   Report Post  
Amie
 
Posts: n/a
Default how do we format a numerical mail merge field


I am trying to format a number in a mail merge document. The number appears
in my excell database as a 2 decimal place figure (have tried formatting as
text and general) and upon merging the document shows many

e.g 2.99 appears in the document as 2.8999999999

Thanks in anticipation

Amie
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Hi, Amie. Try this:
http://www.officearticles.com/word/m...osoft_word.htm
************
Anne Troy
www.OfficeArticles.com

"Amie" wrote in message
...

I am trying to format a number in a mail merge document. The number
appears
in my excell database as a 2 decimal place figure (have tried formatting
as
text and general) and upon merging the document shows many

e.g 2.99 appears in the document as 2.8999999999

Thanks in anticipation

Amie



  #3   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"Amie" wrote in message
...

I am trying to format a number in a mail merge document. The number
appears
in my excell database as a 2 decimal place figure (have tried formatting
as
text and general) and upon merging the document shows many

e.g 2.99 appears in the document as 2.8999999999

Thanks in anticipation

Amie



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
Mail Merge Field window should remain open to insert multiple fiel Steinway60 Mailmerge 1 July 20th 05 04:08 PM
Bug in Word 2003 (mail merge & date format)? Joao Luis Rita Mailmerge 3 June 23rd 05 07:24 PM
Access currency field wont format correctly in word mail merge Marnee Mailmerge 3 June 2nd 05 05:40 AM
How keep my Word format when I mail merge to email? nonprofitCDS Mailmerge 1 May 12th 05 02:09 PM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM


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