How can you change the format on an existing table in Excel to show date/month/year instead of month/date/year? Microsoft is based on the USA style of month/date/year while the rest of the world uses date/month/year.
How to change date format to read date/month/year?
go to CONTROL PANEL and the go to REGIONAL AND LANGUAGE OPTIONS and then you will find a list of countries , chose ( english ( USA ) ) then go to the CUSTOMIZE botton next to the list , and go to DATE tab at the top of the page , and then choose ur format that u desire ,
thx alot , i hope this is what u need !
Reply:My pleasure , no problem at all , ur most welcome !... Report It
Reply:try clicking on the time on the tool bar and change it there and see what happens.
Reply:have you tried this?
Right click the cell, then you choose format cell, then an option will appear try to choose the number tab. On the left corner you choose date then a number of format will appear you just have to choose one.
However if your desired format is not available you may choose custom and there you can give your suggested format..
Hope I helped
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment