[mso] Re: mailmerge using excel and word
- From: "Gareth Edwards" <edwa-mi0@xxxxxxxxxxxxxxxxxxxx>
- To: <russbreese@xxxxxxx>, <mso@xxxxxxxxxxxxx>
- Date: Mon, 30 Jan 2006 10:45:38 +0000
Have you tried using the: Numeric Picture (\#) field switch? On the merge f=
ield. Use the help and search on "numeric switch". In there it will describ=
e how to format a numeric merge field, you will get what you're after with =
using the "x" or decimal point.
Hope that helps...
Cheers,
Gareth Edwards
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Paisley University
x.3748
>>> russbreese@xxxxxxx 29/01/2006 06:01:40 >>>
I created a mail merge document for w-2 s. I built an excel spreadsheet wh=
ich included name, address, etc., and also included a series of numbers. =
Numbers were formatted to 2 decimal places.
The mail merge worked well on the text but my number values would not merge=
exactly as presented in excel. The numbers would be the correct number ex=
cept it would have 12 to 14 decimal places in it. =20
I tried making a new spread sheet, with same results. I tried making a new=
document, same results. What is causing this problem?
Please help.
Thanks, Russ
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or =
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx=20
To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) =
in the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also a=
llow you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso=20
To be able to use the files section for sharing files with the group, send =
a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitatio=
n with instructions. Once you are a member of the files group, you can go =
here to upload/download files:
http://www.smartgroups.com/vault/msofiles=20
*************************************************************
Legal disclaimer
--------------------------
The information transmitted is the property of the University of Paisley an=
d is intended only for the person or entity=20
to which it is addressed and may contain confidential and/or privileged mat=
erial. Statements and opinions expressed in this=20
e-mail may not represent those of the company. Any review, retransmission,=
dissemination and other use of, or taking
of any action in reliance upon, this information by persons or entities oth=
er than the intended recipient is prohibited.
If you received this in error, please contact the sender immediately and de=
lete the material from any computer.=20
--------------------------
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts: