Customising date format
After entering a date as say 2/8/16 it's easy to format it to become
Tuesday 2 Aug 2016 by using 'dddd d mmmm yyyy'. But is it possible to
refine dates further to
Tuesday 2nd August 2016
Wednesday 3rd August 2016
etc ?
Now using Excel 365 on my new Windows 10 PC, after 15 years with XP.
(Not happy at having to pay about £5/month for my occasional use, as I
could not get Excel 2000 from Office Pro 2000 working.)
--
Terry, East Grinstead, UK
|