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.
2007-03-07 17:29:22 · 3 answers · asked by Scallywag 1 in Computers & Internet ➔ Programming & Design
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 !
2007-03-07 17:36:46 · answer #1 · answered by king_aqua_4e 2 · 0⤊ 0⤋
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
2007-03-07 17:38:17 · answer #2 · answered by chiz 2 · 0⤊ 0⤋
try clicking on the time on the tool bar and change it there and see what happens.
2007-03-07 17:33:36 · answer #3 · answered by Big C 6 · 0⤊ 0⤋