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
|
|||
|
|||
Umh !
I have a small problems, and have racked my brains to think of a way
out. So after 2 mins decided I need your help again. I have some code in an excel spreadsheet which says =IF(D130,B13&""&D13&""&J13,""). So far everything is OK, I have the contents of 3 cells into one cell. The problem is B13 has a date format 21-FEB-06, when the B13 date is dispayed with the D13 & J13 in the single cell, the date is displayed as 38721. Is it posible to have the date displayed as it is in B13. |
#2
|
|||
|
|||
Umh !
please try to use MEANINGFUL subject lines for archival purposes.
=IF(D130,text(B13,"mm/dd/yy")&""&D13&""&J13,"") -- Don Guillett SalesAid Software "Decreenisi" wrote in message oups.com... I have a small problems, and have racked my brains to think of a way out. So after 2 mins decided I need your help again. I have some code in an excel spreadsheet which says =IF(D130,B13&""&D13&""&J13,""). So far everything is OK, I have the contents of 3 cells into one cell. The problem is B13 has a date format 21-FEB-06, when the B13 date is dispayed with the D13 & J13 in the single cell, the date is displayed as 38721. Is it posible to have the date displayed as it is in B13. |
#3
|
|||
|
|||
Umh !
Use the TEXT function as in
=IF(D130,TEXT(B13,"dd/mm/yyyy")&""&D13&""&J13,""). You can, of course, use whatever date format you like. -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Decreenisi" wrote in message oups.com... I have a small problems, and have racked my brains to think of a way out. So after 2 mins decided I need your help again. I have some code in an excel spreadsheet which says =IF(D130,B13&""&D13&""&J13,""). So far everything is OK, I have the contents of 3 cells into one cell. The problem is B13 has a date format 21-FEB-06, when the B13 date is dispayed with the D13 & J13 in the single cell, the date is displayed as 38721. Is it posible to have the date displayed as it is in B13. |
Thread Tools | |
Display Modes | |
|
|