Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel Data to MailMerge
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel Data to MailMerge
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" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Excel Data to MailMerge
"macropod" wrote: 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" wrote in message ... 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 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel as mailmerge data source | Mailmerge | |||
"Word was unable to open the Excel data source" Asp.net Mailmerge | Mailmerge | |||
Mailmerge on word using excel data | Mailmerge | |||
Word Field Codes in Excel data file | Mailmerge | |||
Mailmerge wont see Added Excel Data source Columns | Mailmerge |