That's OK providing that you just want to display it that way, and not
calculate as dates.
--
David Biddulph

"Eduardo" wrote in message
...
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?