UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Date format problem    
 
   
Jamie_smith41
post Jul 18 2006, 04:02 AM
Post #1

UtterAccess Enthusiast
Posts: 62
Hi

I am in the process of preparing some spreadsheets that require the following date format:

dd-MMM-YYYY

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

Thanks
Go to the top of the page
 
+
StuKiel
post Jul 18 2006, 05:26 AM
Post #2

UtterAccess Ruler
Posts: 1,182
From: Norfolk UK
Hi Jamie,

If you want to use formula rather than code this will do it for you:

=UPPER(TEXT(A1,"dd-mmm-yyyy"))

Where A1 contains the date you wish to transform, format the cell in which this formula resides as text.

Stu.
Go to the top of the page
 
+
Jamie_smith41
post Jul 18 2006, 05:51 AM
Post #3

UtterAccess Enthusiast
Posts: 62
Thanks very much, that works like a charm!
Go to the top of the page
 
+
StuKiel
post Jul 18 2006, 06:50 AM
Post #4

UtterAccess Ruler
Posts: 1,182
From: Norfolk UK
Glad to help.

Stu.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 03:44 PM