Display date in spanish

M

mbparks

I am using a spreadsheet in a mail merge letter in Word. The front side is
in English and the back side in Spanish. I need to display the mailing date
in Spanish. Is there a way to convert the English text date (December 15,
2009) into Spanish?
I've tried using 2 cells - one for the English and one formatted with a
"Date" format and changing the language to Spanish (Mexico). The date
appears in Spanish in Excel but the number format of the date (12/15/2009)
appears on the letter.
 
A

Arvi Laanemets

Hi


mbparks said:
I am using a spreadsheet in a mail merge letter in Word. The front side is
in English and the back side in Spanish. I need to display the mailing
date
in Spanish. Is there a way to convert the English text date (December 15,
2009) into Spanish?
I've tried using 2 cells - one for the English and one formatted with a
"Date" format and changing the language to Spanish (Mexico). The date
appears in Spanish in Excel but the number format of the date (12/15/2009)
appears on the letter.

Converet dates to datestrings, p.e. with formula
=TEXT(DateReference,"SpanishDateFormat")

When gathering data for Mail Merge, Word doesn't convert strings like it
does with dates or numbers.


Arvi Laanemets
 
M

mbparks

I understand your formula to read as if "DateReference" is the cell
containing the date. Is this correct?
I am not sure how to indicate "SpanishDateFormat". I put the formula with
this text in it but got a #VALUE? error.
 
A

Arvi Laanemets

Hi


mbparks said:
I understand your formula to read as if "DateReference" is the cell
containing the date. Is this correct?
Yes


I am not sure how to indicate "SpanishDateFormat". I put the formula with
this text in it but got a #VALUE? error.


The format string like the one when you use when formatting the date with
Custom format. P.e.

=TEXT(TODAY(),"dd.mm.yyyy") returns '16.12.2009'


=TEXT(TODAY(),"mmmm") returns 'December'

=TEXT(TODAY(),"mmmm, d. yyyy.") returns 'December, 16. 2009.'
etc.



Arvi Laanemets
 
D

David Biddulph

So I think the question was how to get Diciembre instead of December.

Presumably a matter of setting the Windows Regional Options (in Control
Panel, not in Excel) to Spanish?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top