View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
arjen van... arjen van... is offline
external usenet poster
 
Posts: 32
Default change date from 20-Mar-1920 to 20/03/1920 format

If you're simply trying to format the dates in one column, go to Format Cells
and on the Number tab choose custom. In the box where it says type enter:
dd/mm/yyyy. Hit enter and you should be ok.