Can I get date in this format?

[Terry Pinnell]

In Excel 2000 I've used the Customise option
ddd dd mmm
to get my dates looking like this:
https://dl.dropboxusercontent.com/u/4019461/Excel-DateFormat-1.jpg

But those zeros look ugly. Can I remove them so that, for example, row
6 displays as 'Fri 1 Aug' please?

Even nicer would be 'Fri 1st Aug' or even 'Friday 1st August' but I
guess that's defintely impossible without VBA?

 

[Terry Pinnell]

ddd d mmm



Correct

Thanks Ron, appreciate the fast reply. So simple!

I've lost what little VBA knowhow I once had. But I've now written a
macro (with Macro Express Pro) that will take a block of text on the
clipboard in that 'raw' format and convert it to the civilised
'suffixed' form. (It actually turned out to be easier to do from the
'Friday 01 August' input rather than 'Friday 1 August'.)