View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
61Petrus 61Petrus is offline
external usenet poster
 
Posts: 1
Default Converting Day, Date Month Year format to MM/DD/YYYY

I would like to convert cells formatted as

Tue, 4 Oct 1966 00:00:00

to

10/4/1966

How would this best be accomplished.