Mail Merge with Excel

[Protheus]

Hi all,

I have the following problem. I have a letter and I have data in an excel sheet. The excel sheet contains 7 colomns where the first colom is an ID, the second-third-fouth and fith are names of people and locations. Colomn 6 contains % (In format xx%) and 7 contains decimals (in format xx.x)

I have office 2003 and I open the letter, set the datasource to be the excel sheet and view the letter.

The problem is that when I view the % and decimals I see that for the percentages it is displayed as: 0.299999999 % and for some of the decimals it is: xx.yyyyyyyyyyyy

What I did is I added the % in the letter and created a new colomn and added the data again in that column. When I do a mail merge the percentage is displayed correctly (xx%) as I set that the column properties is General.

I try to do the same for the decimals but each mail merge I get xx.yyyyyyyyyyyy on the letter and have No idea how to fix this.

Can anybody assit me in this annoying issue ?

Regards.

 

[Lilliabeth]

http://office.microsoft.com/en-us/word/HA011164951033.aspx#DDE

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[SkipVought]

Hi,

FYI,

FORMAT changes NOTHING wih respect to the VALUE. It only chages what is dipslayed in that application.

So accessing a number like .123456789, that is format to display 12%, you will get .123456789, and it's up to you to FORMAT the data in your application to your liking

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[Wizdar]

Add an apostrophe to the first entry of the problem column(s) (as in ‘xx.x). That should fix the problem.