View Single Post
  #1   Report Post  
date cell configuration
 
Posts: n/a
Default How do i format a 5 to 6 digit number into the correct date?

Currently have thousands of cells entered as 61200 (June 12, 2000) or 101200
(October 12, 2000). When these cells are formated as a dates, the dates show
incorrectly. To save time, need to format the cells as dates without
manually entering two / to seperate the groups of characters as 6/12/00 or
10/12/00.

Thanks