mike (who apparently doesn't like capital letters)
Dim MonthEndDate As Date
Dim MonthEndName As String
MonthEndDate = DateValue("6-30-05")
MonthEndName = CStr(Format(MonthEndDate, "mdyy"))
MsgBox MonthEndName
HTH,
Bernie
MS Excel MVP
"mikeburg" wrote in message
...
How do you strip out dashes, convert numers to a text string, & assign
it to a variable from the following?
monthendate=6-30-05
monthendname=monthendate (need the monthendname to be 63005)
Thank so very much.
mikeburg
--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=387171