How do I change "2006/10/02" to "20061002"
T Trevor Shuttleworth Oct 9, 2006 #2 If you are simply talking about how a date is displayed: If it is formatted as yyy/mm/dd, Format as yyymmdd If it is formatted as yyy/dd/mm, Format as yyyddmm (I can't tell from the example) Regards Trevor
If you are simply talking about how a date is displayed: If it is formatted as yyy/mm/dd, Format as yyymmdd If it is formatted as yyy/dd/mm, Format as yyyddmm (I can't tell from the example) Regards Trevor
B Bob Phillips Oct 9, 2006 #3 If it is a string, then =SUBSTITUTE(A1,"/","") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct)
If it is a string, then =SUBSTITUTE(A1,"/","") -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct)
