Mail merging microsoft word - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 5 (permalink) Old 05-12-2009, 09:09 AM Thread Starter
Lifer
 
zachary's Avatar
 
Join Date: Apr 2003
Posts: 2,882
Mail merging microsoft word

I am using an excel datasheet and creating a mail merge letter in word, got it all down but 1 small problem


i have a decimal number i am trying to import, they are all 6 digit numbers IE .012346

it imports the number as 1.2346 E-2, well i do not want that i want the original decimal number


i have tried EVERYTHING in excel with no results so i am thinking it is in word where i need to change it..any ideas?
zachary is offline  
Sponsored Links
Advertisement
 
post #2 of 5 (permalink) Old 05-12-2009, 09:24 AM
duh...duh....duh
 
ceyko's Avatar
 
Join Date: Aug 2004
Location: ES BEER
Posts: 9,543
Define a little of everything?

Just to be sure the problem is in excel?

I assume you just formated the cell as "general" or something else that makes it a mindless cell?

My '03 Sold.
ceyko is offline  
post #3 of 5 (permalink) Old 05-12-2009, 09:27 AM Thread Starter
Lifer
 
zachary's Avatar
 
Join Date: Apr 2003
Posts: 2,882
Quote:
Originally Posted by ceyko View Post
Define a little of everything?

Just to be sure the problem is in excel?

I assume you just formated the cell as "general" or something else that makes it a mindless cell?
i have formatted the cells in excel in EVERY way possible for a number, in excel the number is 100% .012345, but whenever the merge happens majority of the .012345 turn to the 1.2345 e-2, not all of them do this, but 95% do

so i am thinking the problem is in word not excel....
zachary is offline  
 
post #4 of 5 (permalink) Old 05-12-2009, 09:35 AM Thread Starter
Lifer
 
zachary's Avatar
 
Join Date: Apr 2003
Posts: 2,882
Just in case anyone else needs to know how to do this:


1. With the mail merge main document open, press Alt + F9 to view the field codes

2. The field code will look something like {MERGEFIELD “fieldname” }

3. Directly after the end quote around the field name type \# -- do not add spaces or quotes

4. Directly after the field switch you just entered, type 0.0x if you want to round the number to two decimal places, 0.00x if you want to round the number to three decimal places and so forth

5. Once you have added your field switch, press Alt + F9 to display the fields instead of the field codes
zachary is offline  
post #5 of 5 (permalink) Old 05-12-2009, 10:15 AM
duh...duh....duh
 
ceyko's Avatar
 
Join Date: Aug 2004
Location: ES BEER
Posts: 9,543
I may not be understanding, but if you're not interested in any calculations....why not just make it a general cell or text cell since you jus want the data to merge. The reason I said that is because of your statement "way possible for a number." In this case I don't think it matters if you set it to something else since it won't change what's there, which is what you want.

Otherwise, if it is a problem in word - I'm out on that.

My '03 Sold.
ceyko is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome