Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image
=TEXT(B11,"dd-mmm-yy")

Saqib
Avatar of Murray Brown
Murray Brown
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Thanks very much
Avatar of LFLFM
LFLFM
Flag of Brazil image
http://www.mrexcel.com/forum/showthread.php?t=70772

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

Open in new window