I am in charge of creating all of our old lotus spreadsheets and databases in Excel and Access it has been a chore. You have no idea how long I have been trying to get this to work. Detail discussion of the Text formula in the context of date formatting. Step 4: Now you will get Combine Date & Time in Excel. Step 3: Type this formula TEXT(A2,m/dd/yy )&TEXT(B2,hh:mm:ss) into next column. ![]() In the example shown, column D holds task complete dates. Step 2: A2 indices the first date in Date Column & B2 is for Time Column. Thank you so much Skip, you have such a great wealth of knowledge, I really appreciate your time. To take an action only when the cell is not blank (not empty), you can use a formula based on the IF function. ![]() My only question is the I have other columns that have data in them also and when I go to them I get that same error message, I just select end and it goes on until I get to the column c when I enter there it works fine and enters the date in column D.Ĭan I use this same code for other columns in the sheet and will it work the same way? I have been informed I have to combine three sheets into one and have an auto fill date field in two other columns. I changed that and it seems to enter the date properly. I gotcha, you where correct I had it in the worksheet selection change event.
0 Comments
Leave a Reply. |