Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jason Jason is offline
external usenet poster
 
Posts: 58
Default Currency / Number Formating Issue

Hi

I am using word and excel 2003 when doing a mail merge from excel I have a
field that is for a monetary value i.e £8.94, the excel sheet has been
formated to 2 decimal place.

When its merged to word the field outputs the following £8.9499999999999993.

Can any one advise how to format this correctly.

Thanks
 
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
How do I use field codes to format a number into currency? Andrea Mailmerge 11 January 12th 09 03:50 PM
HOW DO I MAIL MERGE AN EXCEL CELL WITH CURRENCY FORMATING . SLIMSHIM Mailmerge 2 May 4th 07 07:38 PM
Mail Merge Currency Issue [email protected] Microsoft Word Help 2 February 24th 07 12:58 AM
Rounding of currency issue. rflitn Mailmerge 3 August 16th 06 06:05 AM
Text Form Field Formating Issue. Maxwell Microsoft Word Help 6 April 25th 05 08:23 PM


All times are GMT +1. The time now is 03:42 PM.

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"