Date Formatting
in [Functions]
|
Prev: adding figures that match 2 true and 1 false if statement conditio
Next: SELECT SUM(h) WHERE e = 'eBay Payment Sent'
From: DaveMoore on 24 Mar 2010 12:40 With the help of Biff yesterday I entered the formula ="Closing Balance at "&TEXT(E4,"dd-mmm-yyyy") which returned Closing Balance at 31-Mar-2010 exactly as I wanted - almost. My superiors require that to conform with the rest of the document the month element of the date be in upper case, i.e. Closing Balance at 31-MAR-2010 I have tried, in vain and in desperation, the following - ="Closing Balance at "&TEXT(E4,"DD-MMM-YYYY") and ="Closing Balance at "&TEXT(UPPER(E4),"dd-mmm-yyyy") but these do not have the required effect. Does anyone have a solution? Many Thanks, Dave Moore
From: Luke M on 24 Mar 2010 13:19 ="Closing Balance at "&UPPER(TEXT(E4,"dd-mmm-yyyy")) -- Best Regards, Luke M "DaveMoore" <david.moore(a)uuplc.co.uk> wrote in message news:f4c96d0b-f3e8-431e-a5a7-e114a79bc68b(a)y17g2000yqd.googlegroups.com... > With the help of Biff yesterday I entered the formula > ="Closing Balance at "&TEXT(E4,"dd-mmm-yyyy") > which returned > Closing Balance at 31-Mar-2010 > exactly as I wanted - almost. > > My superiors require that to conform with the rest of the document the > month element of the date be in upper case, > i.e. Closing Balance at 31-MAR-2010 > > I have tried, in vain and in desperation, the following - > ="Closing Balance at "&TEXT(E4,"DD-MMM-YYYY") > and > ="Closing Balance at "&TEXT(UPPER(E4),"dd-mmm-yyyy") > but these do not have the required effect. > > Does anyone have a solution? > > Many Thanks, > Dave Moore
From: Daryl S on 24 Mar 2010 13:41
Dave - You were very close: ="Closing Balance at "&UPPER(TEXT(E4,"dd-mmm-yyyy")) -- Daryl S "DaveMoore" wrote: > With the help of Biff yesterday I entered the formula > ="Closing Balance at "&TEXT(E4,"dd-mmm-yyyy") > which returned > Closing Balance at 31-Mar-2010 > exactly as I wanted - almost. > > My superiors require that to conform with the rest of the document the > month element of the date be in upper case, > i.e. Closing Balance at 31-MAR-2010 > > I have tried, in vain and in desperation, the following - > ="Closing Balance at "&TEXT(E4,"DD-MMM-YYYY") > and > ="Closing Balance at "&TEXT(UPPER(E4),"dd-mmm-yyyy") > but these do not have the required effect. > > Does anyone have a solution? > > Many Thanks, > Dave Moore > . > |