Excel 2013 recognized dates as "General"
Hi, Everyone.
I got my new laptop, from windows 7 to windows 10. II am using excel for a lot of time on my windows 7 pc, but when I changed to Windows 10, my excel is not recognizing my data with dates & time. It is showing that the format is in general. Attached file is the sample excel data.
Looking for recommendation/solution.
Thanks,
mike
Hi, welcome to the forum.
Before I look at the file have you checked if your system settings international are the same as when you were working with Windows 7?
Recommendation, check review your system settings
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Here are the screenshot of the system settings:
Windows 7-
windows 7.png
Windows 10:
windows 10.png
They're clearly different. so what do you want us (me) to do for you?
It's YOUR system and EXCEL adapts to YOUR system unless you tell it differently
Hi, What i am telling is that I can't make it similar? I also showed in the screenshot the dropdown list of the dates. I know its different. And I am asking is there a way to fix this date issue??
I see what you mean now, well, not idea, it's a Windows setting.
I guess it's an issue not for Excel but this link might help you
https://www.ablebits.com/office-addi...-format-excel/
Can you change it in the "Additional Settings..."?
@kersplash in additional settings you can just choose from the list of settings vali for that choice, what you can do however is select it to a region that does offer that option and then check that the other settings like decimals currency etc remain the same.
I did not check if there is another language option for the Philippines, could be another option ?
It looks to me like in additional setting you can override the standard settings rather than pick from the pre-defined ones.
I tried but could not manage, my settings are 'messed-up' because the region is the Netherlands but I use the UK settings with US decimal an separator
Hi, Everyone!
Problem solved, thank you for all your help. I overwrite the format using the additional settings and changed it to the same format of my windows 7 pc. I did not think that this setting will be the cause of the date issue in my excel.
Appreciated all your replies.
Thank you,
Mike
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks