Groups

    help with embedded excel sheet in a website and incorrect date format

    I have a website and use an embedded excel spreadsheet in it from my onedrive.

    From my computer it looks fine, however in my tablet and phone the date is in us format. I have looked at setting on my onedrive and hotmail account and all set to English UK, the spreadsheet has been done with English UK date format too.

    Please help me it's doing my head in.

    8 Comments

    I found this ;

    1. Go to account.live.com and sign in with the account you use for SkyDrive
    2. Go Overview -> Personal info
    3. Change Home, Timezone etc to desired location. Change Work location, if required.

    Original Poster

    PulisOut

    I found this ;1. Go to https://account.live.com and sign in with the … I found this ;1. Go to https://account.live.com and sign in with the account you use for SkyDrive2. Go Overview -> Personal info3. Change Home, Timezone etc to desired location. Change Work location, if required.



    ​tried that with no joy. thanks for your help tho.

    As a possible kludge, you could force the date to just be a text string in Excel ...
    e.g. If the real date is in Cell A1, try either the following in the bit of Excel that you're embedding (depending on whether you want leading zeros or not) ...
    =TEXT(DAY(A1),"##")&"/"&TEXT(MONTH(A1),"##")&"/"&TEXT(YEAR(A1),"####")
    =TEXT(DAY(A1),"00")&"/"&TEXT(MONTH(A1),"00")&"/"&TEXT(YEAR(A1),"0000")

    I can't guarantee it, but suspect that would display as you require on your other devices.
    Edited by: "Spango" 14th Sep 2016

    sounds weird I know, but just to test what could be going on. From your computer try setting it in US format and then see what it looks like on tablet and phone. Are these android devices? Do they have settings which need altering?

    Also, unless you are doing some calculus on the dates why not enter the dates as text e.g. ="20/08/1981"
    Edited by: "tardytortoise" 15th Sep 2016

    Original Poster

    Spango

    As a possible kludge, you could force the date to just be a text string … As a possible kludge, you could force the date to just be a text string in Excel ...e.g. If the real date is in Cell A1, try either the following in the bit of Excel that you're embedding (depending on whether you want leading zeros or not) ...=TEXT(DAY(A1),"##")&"/"&TEXT(MONTH(A1),"##")&"/"&TEXT(YEAR(A1),"####")=TEXT(DAY(A1),"00")&"/"&TEXT(MONTH(A1),"00")&"/"&TEXT(YEAR(A1),"0000")I can't guarantee it, but suspect that would display as you require on your other devices.



    ​will look at that now

    Original Poster

    tardytortoise

    sounds weird I know, but just to test what could be going on. From your … sounds weird I know, but just to test what could be going on. From your computer try setting it in US format and then see what it looks like on tablet and phone. Are these android devices? Do they have settings which need altering?Also, unless you are doing some calculus on the dates why not enter the dates as text e.g. ="20/08/1981"



    ​tried it and no joy

    nwressell

    ​tried it and no joy


    you tried entering as text?

    Original Poster

    tardytortoise

    you tried entering as text?



    ​no I'm going to do that next which should work
    Post a comment
    Avatar
    @
      Text
      Top Discussions
      1. Ripped off by GearBest, VERY ANGRY!1719
      2. Iptv1228
      3. Music download79
      4. FedEx sent me a Duty & Tax Invoice - Advice needed67

      See more discussions