Hi there everybody!
I need to enter many dates in a file but they must be always displayed in this text format: "March 4, 2010" and also in Spanish "4 de Marzo de 2010" (or, if too difficult, plain translation "Marzo 4, 2010" is allowed). Is there an Excel formula so that I enter the date in numbers like "03042010" and it yields "March 3, 2010" in another cell and the Spanish date in another cell? Thank you so much, I really appreciate your help.
Regional discrepancies aside perhaps the below would work for you ?
B1: =DATE(RIGHT(A1;4);LEFT(TEXT(A1;"00-00-0000");2);MID(TEXT(A1;"00-00-0000");4;2))
custom format applied to B1 of: mmmm d, yyyy or d "de" mmmm "de" yyyy
where A1 holds number 03042010
To get the date in English date I suspect it would be simplest to run a SUBSTITUTE replacing the month with the English translation.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks