Good morning all,
Recently date formatting changed in my sheet.
This: =TEXT(TODAY();"MM/DD/YY")
Results in this: 02/20/YY
Any idea what could be wrong ?
Good morning all,
Recently date formatting changed in my sheet.
This: =TEXT(TODAY();"MM/DD/YY")
Results in this: 02/20/YY
Any idea what could be wrong ?
Could be a locale thing. Try this instead:
=TEXT(TODAY(),"MM/DD/YY")
Or this maybe:
=TEXT(TODAY();"MM/DD/JJ")
or:
=TEXT(TODAY();"MM/DD/AA")
or whatever the initial letter of your word for year is. Your location in your profile is really unhelpful in this respect!
Last edited by AliGW; 02-20-2022 at 05:10 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks Ali
Already tried that but replacing ; with , result in an error message
It worked ok before. I am not sure when it changed, days / week / months ago.
It is a locale thing - see additions to post above.
Your location details in your profile make this tricky to narrow down! It should be the location you are NOW and reflect the locale of your current machine.
Next time, save us time by telling us what you have already tried.
This, =TEXT(TODAY(),"MM/DD/YY") in UK Regional format, gives me 02/20/22. If I try to enter =TEXT(TODAY();"MM/DD/YY"), I get an error in the formula.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You machine is set to having what/where as the locale???
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh
For me, in the UK:
=TEXT(TODAY(),"MM/DD/AA") returns 02/20/AA
=TEXT(TODAY(),"MM/DD/JJ") returns 02/20/JJ
My point, just for clarity, is that I believe the OP to be using a UK locale (using commas instead of semi-colons), but with date settings set to either Danish (AA) or Dutch (JJ).
This is why he's getting this:
20/02/YY
because his settings are looking for either AA or JJ instead of YY.
It's really irrelevent what a normal/classic and untweaked UK set-up would/will return, because that's clearly not what he's got.
Anyway, I suspect the OP has worked it out for themselves and not bothered to tell us - they disappeared an hour ago.
Last edited by AliGW; 02-20-2022 at 06:12 AM.
> Next time, save us time by telling us what you have already tried.
You are nice as always :-(
Last edited by Duncan-; 02-20-2022 at 07:11 AM.
Please don't take it that way! It just helps if you tell us up front what has already been done to troubleshoot!!!
Has anything here helped you solve the issue? Or did you solve it yourself?
Pleae mark as solved if so. Thanks.
When fiddling for hours I do not keep notes. Sorry.
Not sure why you are pushing so much. Please relax and enjoy the day.
OK - well, I have tried hard to help you here. Have you tried anything I've suggested? What happened when you did?
To try to help you solve the issue!!! If you would prefer me not to care, then I'm very happy to step aside. Just let me know.Not sure why you are pushing so much.
I was just demonstrating the sort of outcome you get if the region/locale does not match the letters you use for the year.It's really irrelevent what a normal/classic and untweaked UK set-up would/will return, because that's clearly not what he's got.
You don't own the thread just because you answered first. And you clearly weren't getting your point across. The OP obviously doesn't know what has changed or why so maybe you should address that.
I don't think I own the thread, Trevor, and I think I did address it: my assumption (that he needs to check and report back on) is that the date settings on his machine have been changed to either Dutch or Danish.
Can't be doing with touchy people. I'm out. Have a lovely Sunday, everyone!
Duncan - I hope you get this resolved.
Turns out I need different formulas on my different systems. This issue was on a system using the US version of excel, but somehow it seems Microsoft uses Dutch settings. Changing YYYY to JJJJ fixed the issue. On my other systems YYYY still works fine.
Thnaks a lot to everybody helping to fix this issue.
Good ol' Microsoft!!
Who's on first? He-he-he-he!
Dave
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
@FlameRetired: Quite possibly my favorite comedy routine of all time.
Originally Posted by shg
@ MrShorty
Yup:
The Mrs. and I have had that conversation many times.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks