I need to change the date format from 01/01/2006 to 20060101 - please help.
G Gord Dibben Nov 22, 2006 #3 =20000000+(YEAR(A5)-2000)*10000+MONTH(A5)*100+DAY(A5) Gord Dibben MS Excel MVP
D Dave Peterson Nov 22, 2006 #4 You can change the format so that the value is kept a date, but is displayed the way you want. Or you could use a formula in another cell: =text(a1,"yyyymmdd") that will return a string. or =--text(a1,"yyyymmdd") that will return a number.
You can change the format so that the value is kept a date, but is displayed the way you want. Or you could use a formula in another cell: =text(a1,"yyyymmdd") that will return a string. or =--text(a1,"yyyymmdd") that will return a number.
