Hi,
Custom format and enter

0"/"00"/"00

"Kbass" wrote:

I would like to know how to turn a number such as "51319" into a date such as
"5/13/19". As of now, when I try to format the cell to a date format, it
completely changes the date from "52309" to a random date such as "7/11/35".
I have no idea why. Any ideas?