decimal spaces toolong when mail merging from excel

I recive data in an excel spreadsheet that contains in one column a number
expressed as " 5.55" which is supposed to be a percentage, but when I try to
mailmerge the data, it mailmerges as "5.55061561650660". In other words it
carries out the decimal place more than 2 digits, which is not what I want. I
have tried formatting the cell, rounding, hand typing the information in
another column and deleting the column that contained the original
information (which I am sure was edited from 5.55061561650660.) How can I fix
this problem so that when I mail merge it comes out as "5.55" only?

Try tools>options>calculations and select precision as displayed before
doing the mailmerge

--
Regards,

Peo Sjoblom


"punkyh" <[email protected]> wrote in message
news:[email protected]...
>I recive data in an excel spreadsheet that contains in one column a number
> expressed as " 5.55" which is supposed to be a percentage, but when I try
> to
> mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> carries out the decimal place more than 2 digits, which is not what I
> want. I
> have tried formatting the cell, rounding, hand typing the information in
> another column and deleting the column that contained the original
> information (which I am sure was edited from 5.55061561650660.) How can I
> fix
> this problem so that when I mail merge it comes out as "5.55" only?

Thank you for the quick response!
I have done this and it still doesn't work.

"Peo Sjoblom" wrote:

> Try tools>options>calculations and select precision as displayed before
> doing the mailmerge
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "punkyh" <[email protected]> wrote in message
> news:[email protected]...
> >I recive data in an excel spreadsheet that contains in one column a number
> > expressed as " 5.55" which is supposed to be a percentage, but when I try
> > to
> > mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> > carries out the decimal place more than 2 digits, which is not what I
> > want. I
> > have tried formatting the cell, rounding, hand typing the information in
> > another column and deleting the column that contained the original
> > information (which I am sure was edited from 5.55061561650660.) How can I
> > fix
> > this problem so that when I mail merge it comes out as "5.55" only?
>
>

Are you mail-merging into Word? If so, then you have to format the data
within the Word environment.

You will probably find that, in Excel, if you remove all the formatting then
the figures you see are those being merged into Word. It's this "raw" data
that Word sees and acts upon. For anyone using Office 97, how you format
your data in Excel is how Word uses it.

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"punkyh" <[email protected]> wrote in message
news:[email protected]...
> I recive data in an excel spreadsheet that contains in one column a number
> expressed as " 5.55" which is supposed to be a percentage, but when I try
to
> mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> carries out the decimal place more than 2 digits, which is not what I
want. I
> have tried formatting the cell, rounding, hand typing the information in
> another column and deleting the column that contained the original
> information (which I am sure was edited from 5.55061561650660.) How can I
fix
> this problem so that when I mail merge it comes out as "5.55" only?

How do I do this?

Thank you for the answer because I was frustrated!

"Andy Wiggins" wrote:

> Are you mail-merging into Word? If so, then you have to format the data
> within the Word environment.
>
> You will probably find that, in Excel, if you remove all the formatting then
> the figures you see are those being merged into Word. It's this "raw" data
> that Word sees and acts upon. For anyone using Office 97, how you format
> your data in Excel is how Word uses it.
>
> --
> Regards
> -
> Andy Wiggins FCCA
> www.BygSoftware.com
> Excel, Access and VBA Consultancy
>
>
> "punkyh" <[email protected]> wrote in message
> news:[email protected]...
> > I recive data in an excel spreadsheet that contains in one column a number
> > expressed as " 5.55" which is supposed to be a percentage, but when I try
> to
> > mailmerge the data, it mailmerges as "5.55061561650660". In other words it
> > carries out the decimal place more than 2 digits, which is not what I
> want. I
> > have tried formatting the cell, rounding, hand typing the information in
> > another column and deleting the column that contained the original
> > information (which I am sure was edited from 5.55061561650660.) How can I
> fix
> > this problem so that when I mail merge it comes out as "5.55" only?
>
>
>

Add a numeric switch to the field (see "Numeric Picture (\#) field
switch" in Word Help). For example:

{MERGEFIELD Field1 \# "0.000" }

In article <[email protected]>,
punkyh <[email protected]> wrote:

> How do I do this?
>
> Thank you for the answer because I was frustrated!
>
> "Andy Wiggins" wrote:
>
> > Are you mail-merging into Word? If so, then you have to format the data
> > within the Word environment.

One more question from the novice....

When I do this in word, how do I do it? For example, I do not change the
data within the Excel Spreadsheet right?

So, when I open the data within the document, how do I edit the information?
Or is this even correct?

Still can't thank you enough.

"JE McGimpsey" wrote:

> Add a numeric switch to the field (see "Numeric Picture (\#) field
> switch" in Word Help). For example:
>
> {MERGEFIELD Field1 \# "0.000" }
>
> In article <[email protected]>,
> punkyh <[email protected]> wrote:
>
> > How do I do this?
> >
> > Thank you for the answer because I was frustrated!
> >
> > "Andy Wiggins" wrote:
> >
> > > Are you mail-merging into Word? If so, then you have to format the data
> > > within the Word environment.
>

Edit the field in the Word document directly. No need to change anything
in the XL file.

See "Format merged data" in Word Help.

In article <[email protected]>,
punkyh <[email protected]> wrote:

> One more question from the novice....
>
> When I do this in word, how do I do it? For example, I do not change the
> data within the Excel Spreadsheet right?
>
> So, when I open the data within the document, how do I edit the information?
> Or is this even correct?
>
> Still can't thank you enough.