I am currently trying to merge numeric data from Excel into an e-mail however
when bringing the data from excel Word is actuall adding on an additional
string of numbers to the number I am trying to merge. Following is an
example.

Number as it appears in Excel Number as it appears in Merge
385.23 385.23000000000001

Any suggestions on how to lose the additional string of information would be
most helpful.

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
"Keith A" Keith wrote in message
...
I am currently trying to merge numeric data from Excel into an e-mail
however
when bringing the data from excel Word is actuall adding on an additional
string of numbers to the number I am trying to merge. Following is an
example.

Number as it appears in Excel Number as it appears in Merge
385.23 385.23000000000001

Any suggestions on how to lose the additional string of information would
be
most helpful.

The other thing to consider is the Excel data. Is the value of the cell
really 385.23, or is is it really 385.230...1 and appearing as 385.23 due to
cell number formatting? Depending on your needs, you might want to apply a
ROUND function to that cell so that it really outputs 385.23.

"Doug Robbins" wrote:

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
"Keith A" Keith wrote in message
...
I am currently trying to merge numeric data from Excel into an e-mail
however
when bringing the data from excel Word is actuall adding on an additional
string of numbers to the number I am trying to merge. Following is an
example.

Number as it appears in Excel Number as it appears in Merge
385.23 385.23000000000001

Any suggestions on how to lose the additional string of information would
be
most helpful.

Word's field formatting does perform this rounding.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"ndolinger" wrote in message
...
The other thing to consider is the Excel data. Is the value of the cell
really 385.23, or is is it really 385.230...1 and appearing as 385.23 due
to
cell number formatting? Depending on your needs, you might want to apply
a
ROUND function to that cell so that it really outputs 385.23.

"Doug Robbins" wrote:

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
"Keith A" Keith wrote in message
...
I am currently trying to merge numeric data from Excel into an e-mail
however
when bringing the data from excel Word is actuall adding on an
additional
string of numbers to the number I am trying to merge. Following is an
example.

Number as it appears in Excel Number as it appears in Merge
385.23 385.23000000000001

Any suggestions on how to lose the additional string of information
would
be
most helpful.