Thread: number to date format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
  
Posts: 1,316
Default number to date format
Replace cell A1 in the expample with the corresponding cell in your worksheet:

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
Kevin Backmann


"womit" wrote:

how do convert a cell with 8 numbers 19680422 into the date format 4/22/1968 ?
Reply With QuoteReply With Quote