Excel Data to MailMerge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mully - 21 Dec 2005 11:22 GMT

Hi All

Below is the Excel data that is imported into Merge

Velocity 1483.1000000000001 ypm

I have tried using below to reduce the digits after the decimal point so
that it reads
Velocity 1483.10 ypm

{MERGEFIELD VELOCITY \ #"$0.00"}

all to no avail --- what 'am I doing wrong????

any help much appreciated

Mully

Reply to this Message

macropod - 21 Dec 2005 23:08 GMT

Hi mully,

If your source data actually reads 'Velocity 1483.1000000000001 ypm', then
you can't use a numeric picture switch to round the numeric part without
losing the rest.

If your source data reads '1483.1000000000001', then you can use a numeric
picture switch to round the result. However, your's isn't coded correctly.
Try"
{MERGEFIELD VELOCITY \# ,0.00}
(be careful with the spacing).

Cheers

> Hi All
>
[quoted text clipped - 13 lines]
>
> Mully

Reply to this Message

mully - 22 Dec 2005 08:48 GMT

> Hi mully,
>
[quoted text clipped - 29 lines]
>
> Hi Macropod

Thanks very much worked first time spot on -- had data formatted in Excel to
-- 2 decimal points changed it to 13 and everything OK --- excel column now a
tad wide but I can live with that

Once again help much appreciated

Cheers

Mully

Reply to this Message