How do you convert the date to DD/MM/YY format in Microsoft Excel?
-
I need to convert the cells to accept the date in this format: Day/Month/Year. I have accomplished this by doing a number of things: 1) ...by creating a Custom number type (DD/MM/YY) in the "Format Cells" option 2) ...by changing the location from US to another country, such as UK or France 3) ...by changing the date format to D/M/Y in the "Text to Columns" section under the Data Tab. HOWEVER, while ALL of these work, they are not consistent. The program rearranges them once new data is entered. Very frustrating. I need to know how to DIRECTLY enter the date February 1, 2003, for example, as 01/02/03. Each time I do this, Excel immediately changes it to 02/01/03 unless I format each individual cell as the information is entered. Can someone please help? Thanks. :)
-
Answer:
Goto Format Date and select Locale (English United Kingdom) and display type dd/mm/yyyy Then just enter the date as you would normally (I gather you are in the US) ie mm/dd//yyyy. The display will change to the UK display but you can work with your own region convention.
Kim at Yahoo! Answers Visit the source
Other answers
I believe that the default date format is taken from the Regional Setting of the operating system, the setting for which you will find in Control Panel>>Regional and Language Settings otherwise you have to format the cells as you have already done individually or as a block using the 'Format Cells.'
Format the cells with the DATE options selecting the one you want. You may have to change from the default language to enable the right options. This worked in Excel when I had it and also works in Open Office.
Try Ctrl "A" and then Format cells... If you "paste" in the data, that might be why this is happening, try "paste special" "unformatted text" that should work. Hope this helps.. Take your mouse and highlight the row or column of where your date will be. - right click - Format cells - Number - Date - look right and choose what way you want the date (DD/MM/YY) If the format you want is not there, - right click - Format cells - Custom - look right and under the "type:" enter DD/MM/YY
Related Q & A:
- How do I convert the image into ASCII format?Best solution by Stack Overflow
- How to change the date format yyyy/mm/dd to dd/mm/yyyy in below code?Best solution by scn.sap.com
- How to convert full date/time to timestamp?Best solution by Stack Overflow
- How do we convert past date into future date?Best solution by Stack Overflow
- How can I convert a video to mp3 format?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.