Excel Data to MailMerge

[mully]

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

 

[macropod]

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

 

[mully]

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 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