I think there may be an issue relating to regional settings. Is '.' a
thousands separator in your Word version?
As fore the first item,
{ =ROUND({MERGEFIELD  Total_Fijo_Mensual},0) }
should give you the nearest whole number.
The second field does not contain a date. You cannot derive a Word date from
it.
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item.  Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.

Hi Gaston,

The problem here seems to be that the mailmerge data are being transferred
in Excel's native format, rather than with the formatting that you applied
there. You can preserve the source data’s formatting by using Dynamic Data
Exchange (DDE).

To choose the DDE data transfer method when you're connecting to an Excel
worksheet during a mail merge, all you have to do is select one check box in
Word:
1. On the Word Tools menu, click Options, and then click the General tab.
2. Click Confirm conversion at Open.

At the step in the mail-merge process where you connect to your data file,
after you locate the file you want to connect to, the Confirm Data Source
dialog box opens. Click “Application via DDE (*.???)”, and then click OK. In
the Application dialog box, select the table/range that contains the
information you want to merge, and then click OK. The data will now be
formatted the same in your merged documents as they look in the source file.

Alternatively, you can code mailmerge fields with the appropriate formulae
and numeric/picture switches.

For 'Total_Fijo_Mensual ', all you'd need to do is add a picture switch to
the field, thus:
 {MERGEFIELD  Total_Fijo_Mensual \# ,0}
This will round off each amount to the nearest whole number. You may want to
do this anyway if your Excel data are formatted to show the decimal values,
but you don't want to show them in your mailmerge or alter your source file.

For 'Fecha_Ult_Increm', the numers you're seeing are the serial values Excel
uses for dates. To fix this you could download my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902
and adapt the field coding under the heading 'Importing Date and Time Values
From Excel and Access' to suit, by changing the 'ImportValue' string to
'MERGEFIELD Fecha_Ult_Increm' and modifying the date & time switch.

Personally, I'd recommend using the DDE connection.

Cheers

Your dates are probably in "Julian date" format which is why Word won't
format them. I do not know why Word sometimes gets them in this format, but
maybe that bit of information will help you identify whether there is
anything unusual about your date column in Excel, or whether creating
another column which refers to the date will help.

I agree with Graham about the numbers.

Peter Jamieson
Thanks Peter,

Total_Fijo_mensual is a formula in excel, and it`s format is currency.
Fecha_ult_increm is a date in excel.
I've tried { DATE \@ "dd/MM/yy" } and it works perfectly,
Thanks for your help.
Gastón

Peter Jamieson ha escrito: