View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Add "/" to a date string

Hi

try marking your columnDataText to columnsNextNextDateM/D/YFinish

--
Regards
Roger Govier

"bpc" wrote in message
...
I have dates of birth entered into a column as 41384 which I would like to
insert the "/" symbol so that the dates read 4/13/84. The month never
includes a leading zero (4 for April not 04), however the day of month
always
does.