Feb 06 2022 06:50 AM - edited Feb 06 2022 06:53 AM
i type in 2/6/22 for Feb 6, 2022 the date change to June 2, 2022 in excel. I tried to change the format that did not help. I need help with this please. It reads 2 as the date the 6 as month. How can I fix this?
Feb 06 2022 06:57 AM
It depends on regional settings for your Windows/Mac/Web/Android, not sure on which platform you are.
Feb 06 2022 06:59 AM - edited Feb 06 2022 07:03 AM
Format a date the way you want
When you enter some text into a cell such as "2/2", Excel assumes that this is a date and formats it according to the default date setting in Control Panel. Excel might format it as "2-Feb". If you change your date setting in Control Panel, the default date format in Excel will change accordingly. If you don’t like the default date format, you can choose another date format in Excel, such as "February 2, 2012" or "2/2/12". You can also create your own custom format in Excel desktop.
Click on the upper Link and you will find more Informations.
*Please also note of Mr Sergei Baklan advice.
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Feb 06 2022 11:26 AM
As Sergei Baklan has already informed you, please be more specific.
Windows version, Excel version, storage medium (OneDrive, hard drive, Sharepoint, etc.).
Here are some small information rules to get a quick and more accurate answer here in the forum.
Welcome to your Excel discussion space!
Settings link/information for the regional settings in Windows.
Manage display language settings in Windows
Change the Windows regional settings to modify the appearance of some data types
Thank you
I know I don't know anything (Socrates)
Apr 28 2022 10:00 AM