How do I convert credit card expiration date stored as myy to mm/yyyy

[bwirth]

New to the forum. I searched but couldn't find an answer to this questions.
I have an old db that outputs credit expiration dates as myy (without the leading 0), e.g. Jan 2023 is 123 whilst December 2023 is 1223. I need to convert this into mm/yyyy. I've tried text-to-columns, custom format, and MID formula, but can't get this right. Appreciate your assistance.

 

[Eric W]

Welcome to MrExcel!

How about:

Book1
	A	B
1	123	01/2023
2	1223	12/2023
Sheet5

Cell Formulas
Range	Formula
B1:B2	B1	=TEXT(A1,"00\/\2\000")

 

[kweaver]

Welcome to Mr. Excel
Actually my thought of a custom format doesn't work.

 

[bwirth]

Hi Eric,

This definitely works!
I was able to use DATEVALUE and custom format to get that to render as MM/YYYY which is what I need to import this into another program

Thanks!