Text to DATE conversion in VBA

A

alicivil

Joined
Jun 8, 2012
Messages
1
Reaction score
0
I am trying to convert the text like"19970101" to 1997/01/01 with date format in excel. I would be thankful if you can give me a VBA code for that.
 
V

vijaydm

Joined
May 25, 2012
Messages
1
Reaction score
0
Hi Alicivil....

Just use ths & change the date format however you want.....No need macro i think...
=TEXT(B3,"0000\/00\/00")+0

reply back if it helps,,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date formatting in VBA 1
compare dates with different formats 2
Excel is changing date format incorrectly 7
Problems with date formats 4
Date format 5
Summarize Data 4
How to convert Text to Numeric 3
Format Cells with VBA? 1

Top