Hi there,
Thanks so much it works fine now.
Have a good one.
Nourredine
2009/6/25 Upendra Singh <upendrasinghsen...@gmail.com>
> Hi Nourredine,
>
>
>
>
>
>
>
> Do as Below :
>
> 1. In the word merged document, right click the merged field for
> which you want to change the format.
>
> 2. Click “Toggle Field Code”
>
> 3. You will see something like { MERGEFIELD Dollar_Value} where
> “Dollar_Value” is the merge Field.
>
> 4. Append \# #,##0.00.
>
> 5. Right Click and Click Update field and You’ve done.
>
>
>
>
>
>
>
> Regards,
>
>
>
> Upendra Singh
>
> +91-9910227325, +91-9310760597
>
>
>
>
> -------------------------------------------------------------------------------------------------------------
>
> There are 10 kinds of people: Those who understand binary and those who
> don’t.
>
>
> -------------------------------------------------------------------------------------------------------------
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *NOURREDINE BELHAJ
> *Sent:* Thursday, June 25, 2009 6:49 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Mail Merge Word Excel 2003
>
>
>
> Hi All,
>
>
>
> Hope you are all fine.
>
>
>
> I have an issue with the Word Function Mail Merge.
>
>
>
> I have an xls with columns Adress Cust Name Invoice Amount Date.
>
>
>
> When I m doing the Mail Merge the Number Format is as below ;
>
>
>
> 6027642.7199999997
>
>
>
> I want to change it to 6,027,642.72
>
> Can you please help with this
>
>
>
> Thanks
> --
> Regards
>
> Nourredine BELHAJ
>
> +41783081988
> +33665248617
>
>
>
> >
>
--
Regards
Nourredine BELHAJ
+41783081988
+33665248617
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
