Merging Excel Data to an E-mail Document

[Guest]

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.

 

[Doug Robbins]

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

 

[Guest]

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.

 

[Suzanne S. Barnhill]

Word's field formatting does perform this rounding.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.