Excel VBA convert date to string

Hi

I have an Excel cell that holds a date in the format 2010/11/08.
How do I convert this to a string value 08-Nov-10
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
SiddharthRoutCommented:
Lets say the date is in cell A1

then try this

Msgbox Format(Range("A1").Value,"dd-mmm-yy")

Sid
0
 
Saqib Husain, SyedEngineerCommented:
=TEXT(B11,"dd-mmm-yy")

Saqib
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
LFLFMCommented:
http://www.mrexcel.com/forum/showthread.php?t=70772

MYSTRING=FORMAT(Range("A1").Value,"yyyymmdd")

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.