Can I get date in this format?


Ad

Advertisements

T

Terry Pinnell

Ron Rosenfeld said:
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'.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top