Thread
:
change date from 20-Mar-1920 to 20/03/1920 format
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
arjen van...
external usenet poster
Posts: 32
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.
Reply With Quote
arjen van...
View Public Profile
Find all posts by arjen van...