Thread: Format Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Chris is offline
external usenet poster
 
Posts: 788
Default Format Date

I have a column with the data type as general - This column should be a date

Sample data
20051231
20051230
20051229
20051228
20051227

I would like to write a rutine that would convert the date to

12/31/2005
12/30/2005
12/29/2005
12/28/2005
12/27/2005

Please I need help!!!!!!

thank you in advance