asked on
Excel 2011 Date Format
Hi all,
I am using Excel 2011 for the Mac for the first time and have noticed that when I input a date into a cell using the UK format (dd/mm/yyyy) it always shows the US format (mm/dd/yyyy) when I exit from the cell. I have tried all the usual format changes to change it but it doesn't work.
Does anyone know how to fix this - I am new to Macs so I may need you to spell it out simply for me to find my way around.
Cheers,
Tom
I am using Excel 2011 for the Mac for the first time and have noticed that when I input a date into a cell using the UK format (dd/mm/yyyy) it always shows the US format (mm/dd/yyyy) when I exit from the cell. I have tried all the usual format changes to change it but it doesn't work.
Does anyone know how to fix this - I am new to Macs so I may need you to spell it out simply for me to find my way around.
Cheers,
Tom
Microsoft Excel
Last Comment
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Cheers Teylyn... That sorted it. I've heard so many people say that once you get used to Mac you wont go back! Not too sure if thats true yet from what you said!!
Thanks again...
Tom
Thanks again...
Tom
Thanks for the grade, Tom.
Apart from the iPhone, which was issued to me by my employer, and the iPad, which I got as a fun tool for the kids last year, I don't have any recent Mac experience. I can see some benefits for the very basic user (like my husband), but I'm not too fond of the (lack) of customisation on offer.
Some things are very easy to do. Others are absolutely impossible, at least not the way the regular DOS/Windows person excpects them to be. Others again, are outright forbidden (tethering the iPad with an iPhone to the internet, OMG!!).
My early-career Mac experience did not go down too well, and I still have this bad taste in my memory....
My husband is soon due for a replacement computer. We've been toying with the "Mac" idea, but I'm not convinced that I would be able to support him, given his two (or three?) left hands and propensity to run into deep trouble, especially when I'm out of reach.
I think, I'll stick with Windows for the time being.
Excuse the blurb. Sometimes, an expert needs to vent.
Hope all is well with your setup now.
cheers, teylyn
Apart from the iPhone, which was issued to me by my employer, and the iPad, which I got as a fun tool for the kids last year, I don't have any recent Mac experience. I can see some benefits for the very basic user (like my husband), but I'm not too fond of the (lack) of customisation on offer.
Some things are very easy to do. Others are absolutely impossible, at least not the way the regular DOS/Windows person excpects them to be. Others again, are outright forbidden (tethering the iPad with an iPhone to the internet, OMG!!).
My early-career Mac experience did not go down too well, and I still have this bad taste in my memory....
My husband is soon due for a replacement computer. We've been toying with the "Mac" idea, but I'm not convinced that I would be able to support him, given his two (or three?) left hands and propensity to run into deep trouble, especially when I'm out of reach.
I think, I'll stick with Windows for the time being.
Excuse the blurb. Sometimes, an expert needs to vent.
Hope all is well with your setup now.
cheers, teylyn
Where do you get to make changes/check the system date default on a MAC please?
Tom