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. |
Thread Tools | |
Display Modes | |
|
|