Google spreadsheets

flyer

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?

tronator

flyer wrote: »

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)".

flyer

Everything's already set to English

BillScarab

Click on File, Spreadsheet settings and change the locale to United Kingdom.

flyer

I've done some more digging and just found the answer. It's in the 123 format.

Thanks anyway.

nikork

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!

tronator

flyer wrote: »

Everything's already set to English

I was sure it was, but did you spot the difference between "English (US)" and "English (UK)"?

flyer wrote: »

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?

flyer

tronator wrote: »

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?