Thread
:
dates
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein
external usenet poster
Posts: 5,934
dates
Try
=SUBSTITUTE(TEXT(A1,"dd/mm/yy"),"/","")
Why not just this instead...
=TEXT(A1,"ddmmyy")
--
Rick (MVP - Excel)
Reply With Quote
Rick Rothstein
View Public Profile
Find all posts by Rick Rothstein