Jul 18 2006, 04:02 AM
I am in the process of preparing some spreadsheets that require the following date format:
I have used custom format, but it will insist on dropping the UPPER CASE month (e.g. JAN). Does anybody know a way around this problem
Jul 18 2006, 05:26 AM
If you want to use formula rather than code this will do it for you:
Where A1 contains the date you wish to transform, format the cell in which this formula resides as text.
Jul 18 2006, 05:51 AM
Thanks very much, that works like a charm!
Jul 18 2006, 06:50 AM
Glad to help.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here