Hi all,
Need some help, how can i convert "Date and Time " format in a column to reflect only "Date". ( through VBA )
eg, 11/23/2018 8:28:14 AM
should get converted to
11/23/2018
Date and time format is available in "B" column, so i need code to convert this in to date in the specific column.
Thank you
If I have helped you in someway, use the * icon below to give reputation feedback, it is appreciated.
If it's always going to be in mmddyyyy format then you can simply use;
If not, then look for the space;
Please Login or Register to view this content.
Excel should automatically convert it to a date for you.Please Login or Register to view this content.
Hi,
This is just converting only for value in Cell "B1".
But i have data in entire column B. sometime data will be from B2 to 200 or may be more or less.....
i need this conversion to happen whatever the data available in B column.
Try:
If you only want to change how it is displayed.Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Hi Arkadi,
Not just displaying, I don't want those time in the cells.
Just need to have only dates in the columns.
Maybe:
Please Login or Register to view this content.
Or, alternatively:
Please Login or Register to view this content.
Last edited by XLent; 11-26-2018 at 02:28 PM. Reason: whoops - reinstated previously removed Parent reference
I had this same issue and rather than using a script I split the column by the number of digits in the time. In my case it was using a XX:XX:XXPM style time. I counted the digits and put the split after that. Worked like a charm.
But you never said that when you asked so I just assumed you'd be able to work with what I gave you.Originally Posted by prabhuduraraj09
If there is only this format in Col B and no other data types then;
Please Login or Register to view this content.If there are other data types in Col B then please give an example of what they can look like.
Last edited by PaulSP8; 11-26-2018 at 07:37 PM. Reason: Left the 1 and didn't replace with i :(
Paul, Arkadi, Xlent
Thanks to All of you guys for your contribution.
Appreciate the effort and help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks