Hi Nourredine,
Just insert a column next to your invoice amount date and use =round(cell
name,2).
Use this new cell reference in your mail merge. That'll do
Cheers,
Sri
On Thu, Jun 25, 2009 at 6:48 PM, NOURREDINE BELHAJ <
nourredine.bel...@gmail.com> wrote:
> Hi All,
>
> Hope you are all fine.
Hi there,
Thanks so much it works fine now.
Have a good one.
Nourredine
2009/6/25 Upendra Singh
> 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
HI,
This is more like a word forum issue?
Anyways, here is the solution.
You need to do it in word than in excel.
After you start mail merge and before you update all the fields (merged
fields), you need to get the individual field codes in the document. Once
you get the field codes
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. Ap
Hi Dilip,
It doesn t wotk it comes back when merging
6027642.719997
2009/6/25
>
> Hi Nourredine,
>
> Try changing the number format in MS Excel itself. To achieve this, Go to
> Format - > Cells -> On the Number tab, choose "number" with two decimal
> places and check "Use 1000 Seperator (
Hi Nourredine,
Try changing the number format in MS Excel itself. To achieve this, Go to
Format - > Cells -> On the Number tab, choose "number" with two decimal
places and check "Use 1000 Seperator (,)".
After changing the number format, continue with your mail merge.
Thanks,
--
DILIP KUMAR PA
