Date formatting
Thank You all....
"Gary''s Student" wrote:
An alternative:
=YEAR(A1)*10000+MONTH(A1)*100+DAY(A1)
and format the cell as General. So if A1 contains =TODAY(), then the
formula will return: 20060510
--
Gary''s Student
"nick" wrote:
Hi,
How do i convert a standard date in to yyyymmdd format? I have to use a
function to do this. I cannot just change the format of the cell. Can anyone
help me with this? Thanks
|