View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hawkins,K Hawkins,K is offline
external usenet poster
 
Posts: 1
Default Converting 20010321 to 03/21

I've tried every type of format available and tried to custom make one.
Please help! I have a whole column of birthdates listed as 20010321
(yyyymmdd) and I need them to read only the mm/dd. General steps
appreciated. thx!