View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kbass Kbass is offline
external usenet poster
 
Posts: 1
Default Turning numbers into Dates

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?