View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JethroUK©
 
Posts: n/a
Default Convert Date to number?

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"