Converting Date field in Cell from DD-MMM-YY to YYYYMMDD

ctoenes

New member
Joined
Sep 26, 2013
Messages
3
Reaction score
0
Points
0
I've been trying to get this going with no luck so far, can anyone provide assistance please? Example is 25-Nov-13 needs to 20131113 for outbound EDI.

Thanks for your support!
-Chad
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
Hello,

=Text(--Target Cell--,"YYYYMMDD")

Good luck,
 

ctoenes

New member
Joined
Sep 26, 2013
Messages
3
Reaction score
0
Points
0
:rockon: Thank you very much !!!!!! it worked great...been tickin me off most of the morning...owe ya one!
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
Excellent. Glad to help. The text function is amazing. Microsoft has a very good page on it too if you want to google it.

You're very welcome,
 
Top