LinkBack URL
About LinkBacks
Cell & " " & Nextcell
doesn't work when trying to copy the date along with text of another cell. It turns the date into some weird number. Anyway I can get around this so I can see the date from one cell and the text of another a space after that?
Cell & " " & Nextcell
doesn't work when trying to copy the date along with text of another cell. It turns the date into some weird number. Anyway I can get around this so I can see the date from one cell and the text of another a space after that?
Handle the date like this:
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
I played around with your format, but couldn't get anything other than "Microsoft Office Excel cannot use the number format you typed." And what do I replace 'yourvariable' with? I tried using the cell I am getting the date from, then removing it all together. What should I do?
Please post a sample of your workbook including the code you are working with and I'll take a swing at it.
let us say you have date in cell A1 and some text in cell B1, put this in cell C1:
=TEXT(A1,"dd-mmm-yy")&" "&B1
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Perfect Icestation. That works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks