xizor
asked on
formating date
I want to format the date to loose the seperators:
eg: 7/11/2006 to 7112006
Idea on how?
cheers,
`Andy
eg: 7/11/2006 to 7112006
Idea on how?
cheers,
`Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
x =replace(7/11/2006,"/","")
MsgBox (Replace(Date, "/", ""))
msgbox(replace("7/11/2006" ,"/","")) or MsgBox (Replace(Date, "/", ""))