Hello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format.i tried applying the format we have in excel format cell date format but nothing is happening.please help me on this.
If it is in YYYYMMDD format
select the column go to DATA TAB
select text to columns
give two next and in third one select date radio button and select YMD format this will be converted to D/M/YYYY format dont get panic
now select the same row with d/m/yyyy format and right click and select fomat cells in that select date in locale select english(u.k) browse for any date option on top and select it....
simple now YYYYYMMDD converted to YYYY-MM-DD
if you tell me that you have tried to change the format in excel and nothing happens then there must surely be some problems with your microsoft office and try to uninstall it and then reinstall it it should work fin and I really cant understand why it does want to change the format...