I have a database field called Table Number that contains whole numbers only e.g. 1, 10, etc. and that's the way it appears in my database.

I don't remember ever having this problem; however, when I use that number field in a merge document, it is followed by a decimal point and 8 zeroes.

1 becomes 1.00000000
10 becomes 10.00000000

I want the merged fields to show whole numbers only, just as it does in the database.

What do I need to do to fix this?

Thanks!

Word Merge

Carl -

Maybe I misunderstood when you asked if I was using "WordMerge" because what you just said is not familiar to me.

I am using Microsoft Word Version 2010

If it takes "figuring out" perhaps it's not worth the trouble.  I merged the document and simply did a "replace" of the .00000000 with "nothing". 

I was just curious because I never had this happen before and I am not aware of anything that I did differently.  As far as I know the number field itself is set to NOT display any decimals.

Carl -

I'm not sure what "code" you are referring to, so let me tell you the way I did this particular merge.

I retrieved the records I want from a database

I exported the appropriate fields and save it into a file called mergeinfo.csv .  The export looks like this, for the "number" field:

Table
9
11
11
2
6
6

I open an MS Word document that has an "insert merge field" that looks like this:

Table «Table»
Table «Table»
Table «Table»
Table «Table»
Table «Table»
Table «Table»

When I "preview" or actually merge the data in MS Word, this is what I get:

Table 9.00000000
Table 11.00000000
Table 11.00000000
Table 2.00000000
Table 6.00000000
Table 6.00000000

I can't seem to get the "image" insert to work, but if you click on the following link, you'll see an example of one of the finished products.  Look at TABLE on the bottom of the merged form.

https://www.dropbox.com/s/4tb537utdhjpyo1/Capture.JPG?dl=0

Once again, I have already completed my merges, so it is not "critical" for me.

We use a lot of mail merge in our application.  the format that I use is {MERGEFIELD "GRAMSSLUG"\#0.00}.

THIS FORMAT (#0.00) PLACED AFTER THE MAIL MERGE ELEMENT WILL PROVIDE UNLIMITED NUMBERS BEFORE THE DECIMAL POINT AND TWO DECIMAL PLACES AFTER THE DECIMAL POINT.