View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Betmck Betmck is offline
external usenet poster
 
Posts: 2
Default change date format.

I have an excel 2003 file with 1500 dates in one column . The format is
10/31/2006 I have to import these dates into Microsoft Dynamics 9.0-fixed
assets. To import, the date format should be 10312006. Is there a function
that could strip the '/' out? could someone assist me with this task. Thanks
--