ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Format dates from English to Spanish (https://www.excelbanter.com/excel-worksheet-functions/215913-format-dates-english-spanish.html)

FA

Format dates from English to Spanish
 
My computer is formated in English. I work with both, Spanish and English
languages. I have a list of dates that are formated in Spanish, with the
date order as "d/mmm/yyyy".

They read 5-Jan-2008, 7-Apr-2008, 15-Aug-2008,etc.

I need those dates to be instead of Jan, Ene or Aug, Ago or Apr, Abr.

How can I do this?

Jarek Kujawa[_2_]

Format dates from English to Spanish
 
Excel 2003

Format-Cells-Date-Regional Settings

and select yr country

On 9 Sty, 13:52, FA wrote:
My computer is formated in English. *I work with both, Spanish and English
languages. *I have a list of dates that are formated in Spanish, with the
date order as "d/mmm/yyyy".

They read 5-Jan-2008, 7-Apr-2008, 15-Aug-2008,etc.

I need those dates to be instead of Jan, Ene or Aug, Ago or Apr, Abr.

How can I do this?



David Biddulph[_2_]

Format dates from English to Spanish
 
Change the Windows Regional Options (in Control Panel).
--
David Biddulph

"FA" wrote in message
...
My computer is formated in English. I work with both, Spanish and English
languages. I have a list of dates that are formated in Spanish, with the
date order as "d/mmm/yyyy".

They read 5-Jan-2008, 7-Apr-2008, 15-Aug-2008,etc.

I need those dates to be instead of Jan, Ene or Aug, Ago or Apr, Abr.

How can I do this?





All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com