help with embedded excel sheet in a website and incorrect date format - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

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

£0.00 @
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 m… Read More
nwressell Avatar
9m, 1w agoPosted 9 months, 1 week ago
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.
nwressell Avatar
9m, 1w agoPosted 9 months, 1 week ago
Options

All Responses

(8) Jump to unreadPost an answer
Responses/page:
#1
I found this ;

1. Go to https://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.
#2
PulisOut
I found this ;

1. Go to https://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.


tried that with no joy. thanks for your help tho.
#3
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 on Sep 14, 2016 21:54
#4
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 on Sep 15, 2016 09:11: extra info
#5
Spango
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
#6
tardytortoise
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
#7
nwressell
tardytortoise
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
you tried entering as text?
#8
tardytortoise
nwressell
tardytortoise
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
you tried entering as text?


no I'm going to do that next which should work

Post an Answer

You don't need an account to leave a response. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!