+ Reply to Thread
Results 1 to 7 of 7

Spanish translation formula

  1. #1
    Registered User
    Join Date
    02-25-2007
    Posts
    98

    Question Spanish translation formula

    Hello,

    Anyone know of a formula to translate a date (month, day, year) into Spanish? So an English version cell would contain (January 6, 2016) and the Spanish would contain (Enero 6, 2016) all without me having to go and translate it manually.

    I have a spreadsheet that will automatically insert todays date [=NOW()] when opened. Below in a Spanish translated version I need the date to translate also.

    Thanks

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    16,841

    Re: Spanish translation formula

    http://excelribbon.tips.net/T011782_..._Function.html

    Look at this link

  3. #3
    Registered User
    Join Date
    02-25-2007
    Posts
    98

    Re: Spanish translation formula

    Ok that will change it to Spanish. But how do I get it to automatically display todays date? if I insert the formula =NOW() I will get todays date, I just need it in Spanish.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    19,485

    Re: Spanish translation formula

    Will the file be used on a PC which is set up to use Spanish in the Regional settings? If so, then it will be translated automatically.

    Hope this helps.

    Pete

    EDIT: By the way, =NOW() inserts the date AND the time. If you only want the date then use =TODAY() instead.

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,791

    Re: Spanish translation formula

    Try to use this celformat:
    [$-C0A]mmmm d, jjjj
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  6. #6
    Registered User
    Join Date
    02-25-2007
    Posts
    98

    Re: Spanish translation formula

    Thanks, Alan, Pete and Popipipo

    Anyone know how I can format it to capitalize the month? It displays in all lower case.

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Spanish translation formula

    maybe
    A1: =TODAY()
    B1: =UPPER(TEXT(A1,"[$-C0A]dd mmmm yyyy, dddd")) - 08 ENERO 2016, VIERNES
    or
    B1: =PROPER(TEXT(A1,"[$-C0A]dd mmmm yyyy, dddd")) - 08 Enero 2016, Viernes

    without cell formatting
    Last edited by sandy666; 01-07-2016 at 07:35 PM. Reason: = added
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1