A alicivil Joined Jun 8, 2012 Messages 1 Reaction score 0 Jun 8, 2012 #1 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.
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 Jun 8, 2012 #2 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,,
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,,