Prev: macro shortcut help
Next: SUMIFS using a text range
From: DaveMoore on 23 Mar 2010 13:12
A date has been entered in cell E4, 31/03/2010 but has been formatted
so as to display as MAR-10. That's okay, that's what I want.
I now wish to refer to that cell at B12 using the following -
="Closing Balance at "&E4
However, this displays as Closing Balance at 40268
I think I have to format the date reference 40268 within my formula in
B12 but do not have a clue how to do that.
The format I want to display is 31-MAR-2010
Can anybody advise?
Many Thanks,
Dave Moore

From: T. Valko on 23 Mar 2010 13:15
Try it like this...

="Closing Balance at "&TEXT(E4,"mmm-yy")

--
Biff
Microsoft Excel MVP


"DaveMoore" <david.moore(a)uuplc.co.uk> wrote in message
news:de17e840-03f6-4e80-bd10-ec31e944f86d(a)i25g2000yqm.googlegroups.com...
>A date has been entered in cell E4, 31/03/2010 but has been formatted
> so as to display as MAR-10. That's okay, that's what I want.
> I now wish to refer to that cell at B12 using the following -
> ="Closing Balance at "&E4
> However, this displays as Closing Balance at 40268
> I think I have to format the date reference 40268 within my formula in
> B12 but do not have a clue how to do that.
> The format I want to display is 31-MAR-2010
> Can anybody advise?
> Many Thanks,
> Dave Moore
>


 | 
Pages: 1
Prev: macro shortcut help
Next: SUMIFS using a text range