|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 23rd, 2010, 05:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
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 
|
|
#2
March 23rd, 2010, 05:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
Try it like this...
="Closing Balance at "&TEXT(E4,"mmm-yy") -- Biff Microsoft Excel MVP "DaveMoore" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
