We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Google spreadsheets
Options

flyer
Posts: 2,279 Forumite


in Techie Stuff
I really want to get on with Google spreadsheets, because I think it's the best way to view and edit them at home and remotely.
The problem is I have a large spreadsheet created in Excel, where the first column is the date in dd/mm/yr format, but when I view it in Google docs, it converts to the American version of mm/dd/y.
I can't see how to change that. Any ideas?
The problem is I have a large spreadsheet created in Excel, where the first column is the date in dd/mm/yr format, but when I view it in Google docs, it converts to the American version of mm/dd/y.
I can't see how to change that. Any ideas?
Even if you are a minority of one, the truth is the truth.
0
Comments
-
I really want to get on with Google spreadsheets, because I think it's the best way to view and edit them at home and remotely.
The problem is I have a large spreadsheet created in Excel, where the first column is the date in dd/mm/yr format, but when I view it in Google docs, it converts to the American version of mm/dd/y.
I can't see how to change that. Any ideas?
I guess your account is set to "English (US)". After logging in go to settings and change it to "English (UK)".0 -
Everything's already set to EnglishEven if you are a minority of one, the truth is the truth.0
-
Click on File, Spreadsheet settings and change the locale to United Kingdom.It's my problem, it's my problem
If I feel the need to hide
And it's my problem if I have no friends
And feel I want to die0 -
I've done some more digging and just found the answer. It's in the 123 format.
Thanks anyway.Even if you are a minority of one, the truth is the truth.0 -
I have a problem on my excel spreadsheet that I can't resolve. Can anyone help?
I am making a line graph. I have dates Jan-Feb along the bottom and scores 1-10 up the left. I want to enter multiple series showing what scores were given for each month. With me so far?
So when I enter just one series it come out great, with data points at the correct score/date. But, when I enter a second series of scores they are added on to the previous scores. So now my scores up the left go right up to say 16, if there was an 8 and an 8 on the same date for different series.
I can email the spready over if anyone want to help...
Thank you techy people, your colleagues need you!0 -
Everything's already set to English
I was sure it was, but did you spot the difference between "English (US)" and "English (UK)"?I've done some more digging and just found the answer. It's in the 123 format.
Thanks anyway.
This solved it for this document, but how about the next one you'll create?0 -
I was sure it was, but did you spot the difference between "English (US)" and "English (UK)"?
This solved it for this document, but how about the next one you'll create?
1. I had it set to English (UK)
2. Interestingly, a new spreadsheet formats it correctly. I wonder if it was because it was an existing spreadsheet?Even if you are a minority of one, the truth is the truth.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.7K Banking & Borrowing
- 253K Reduce Debt & Boost Income
- 453.4K Spending & Discounts
- 243.7K Work, Benefits & Business
- 598.5K Mortgages, Homes & Bills
- 176.8K Life & Family
- 256.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards