J
JethroUK©
How would i convert a date to number as a string
e.g. 10/05/2005 > "20050510"
note the month is 2 digit - 05
i cant see Format(A1,"yyyy,mm,dd") & i tried = year(a1) & month(a1) &
day(a1)
but it returns month as single "2005510"
e.g. 10/05/2005 > "20050510"
note the month is 2 digit - 05
i cant see Format(A1,"yyyy,mm,dd") & i tried = year(a1) & month(a1) &
day(a1)
but it returns month as single "2005510"