I'm currently following the date type dd/mm/yyyy i need to have another row showing the month in mmm type. E.g. From 13/09/2014 to SEP
My formula is =Text(A2, "mmm") which is the correct formula,
However it reads the text as mm/dd/yyyy thus having an error. How do I tell the excel to read it in dd/mm/yyyy format.
The format of the dd/mm/yyyy field is General - No specific format
Answer
If you want it to apply for just this Excel formula, Overmind's answer covers how. If you want it to apply always to everything, you have to change the system's date format.
Note that this will change every date displayed that uses system settings as well as changing how you must type in dates. For instance, if you change the system short date format to d/M/yyyy and then type 9/13 into Excel, it'll assume you meant September 1, 2013, because 13 doesn't make sense as a month so it must be a year and that means that 9 must be the month.
Here are the screenshots showing how to change the system's time format on Windows 7.
Right-click on the time in the system tray and click Adjust date/time
Click on Change date and time...
Click on Change calendar settings
Change the format as desired and click OK
No comments:
Post a Comment