Dear Sir,

For Example is :

2785.000000000000002

I want in MS Word when i use mail merge

2785.00 or 2785.20

but word in always show first above number format. (2785.0000000000002)

My operating system xp and MS office Professional genuine and registered
version.

This function is more use in my work. Please this problem is big for me
instantly resolve.

Thanking You

Jayesh Soni

Cindy show how at
http://homepage.swissonline.ch/cindymeister/mergfaq.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Jayesh" wrote in message
...
Dear Sir,

For Example is :

2785.000000000000002

I want in MS Word when i use mail merge

2785.00 or 2785.20

but word in always show first above number format. (2785.0000000000002)

My operating system xp and MS office Professional genuine and registered
version.

This function is more use in my work. Please this problem is big for me
instantly resolve.

Thanking You

Jayesh Soni

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

Jayesh wrote:

Dear Sir,

For Example is :

2785.000000000000002

I want in MS Word when i use mail merge

2785.00 or 2785.20

but word in always show first above number format. (2785.0000000000002)

My operating system xp and MS office Professional genuine and registered
version.

This function is more use in my work. Please this problem is big for me
instantly resolve.

Thanking You

Jayesh Soni



--

Dave Peterson