terrypin Posted July 15, 2014 Report Share Posted July 15, 2014 In my aging Excel 2000 I frequently enter a column of dates like this: 28/7/14 29/7/14 etc (Of course, that's using the logical not the USA style! ) It's easily formatted to look like this: I find those leading zeros ugly, although I can quickly remove them in my text editor with a simple global replacement. However I would ideally like instead to see Friday 1st AugustSaturday 2nd Augustetc Before I start coding, I wonder if anyone already has or knows of a macro to do it please? Needless to say, it's arguable whether it's worth the effort. My list of dates is never very long and I could manually add the suffixes in a couple of minutes. But where's the fun in that? --Terry, East Grinstead, UK Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.