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
flyer Posts: 2,279 Forumite
Part of the Furniture 1,000 Posts Name Dropper
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?
Even if you are a minority of one, the truth is the truth.

Comments

  • tronator
    tronator Posts: 2,859 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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
    flyer Posts: 2,279 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    Everything's already set to English
    Even if you are a minority of one, the truth is the truth.
  • BillScarab
    BillScarab Posts: 6,027 Forumite
    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 die


  • flyer
    flyer Posts: 2,279 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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.
  • nikork
    nikork Posts: 2 Newbie
    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
    tronator Posts: 2,859 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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
    flyer Posts: 2,279 Forumite
    Part of the Furniture 1,000 Posts Name Dropper
    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?
    Even if you are a minority of one, the truth is the truth.
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

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

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.