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

[ctoenes]

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]

Hello,

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

Good luck,

[ctoenes]

Thank you very much !!!!!! it worked great...been tickin me off most of the morning...owe ya one!

[bgoree09]

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,