Greetings,
1- Open enclosed file.
2- Run Macro1.
3- See that F2+Enter macro works perfectly.
Please Login or Register to view this content.
Question: I dont want to use F2+Enter macro for some reasons... Any advice without using F2+Enter macro will be appreciated...
I dont want to use sendkeys method...
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
What does pressing F2 do?
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hi Mike,
F2 + Enter is creating proper date numbers...
In order to see how, please run Macro1 in the enclosed file...
Why this duplicate thread ?‼
This is not duplicate thread. Because this time data is in "date" format...Originally Posted by Marc L
Hi Herry,
I am really confused what you intend to do? F2 + Enter for what reasons? Do you want to convert text in Column A to date format?
Yes, exactly.
I don't see F2, Enter doing what you want.
Please Login or Register to view this content.
Hi Herry,
You don't need a macro to do this. It just a simple excel Formula
put in at column B starting on B2 and drag down this formula
=DATE("20"&RIGHT(A2,2),RIGHT(LEFT(A2,5),2),LEFT(A2,2))
Thanks Kenneth Hobson.
Thanks Faridwahidi.
Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks