Thread
:
Remove slash charaters from a date field
View Single Post
#
2
Posted to microsoft.public.excel.misc
MyVeryOwnSelf[_2_]
external usenet poster
Posts: 143
Remove slash charaters from a date field
How do I remove the slash characters from a date field. I have
converted all the date formats to text and need a way to remove the
slashes.
One way:
=SUBSTITUTE(A1,"/","")
Reply With Quote
MyVeryOwnSelf[_2_]
View Public Profile
Find all posts by MyVeryOwnSelf[_2_]