LinkBack URL
About LinkBacks
how can i convert the .csv file date format to excel date format time.
the .csv format date is coming as 10-MAR-15
Regards
Arndam
how can i convert the .csv file date format to excel date format time.
the .csv format date is coming as 10-MAR-15
Regards
Arndam
Try using =DATEVALUE() in a helper cell/column
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi
The Date () formula also is not working for me,
I have uploaded the file please check,
Request you to please explain your formula how it’s works then I can learn
Regards
Arindam
Thats not what I saidThe Date () formula also is not working for me,
I said DATEVALUE()
Try that, and in the mean time I will take a look at your file
OK another approach for what you have there...
Highlight the entire range
scroll up until you see the yellow triangle (you may not even need to scroll up)
click that and select the Convert To Date
No both of your suggestion is not working for me.please help me with a formula
@Ford
I've been playing with this....what about putting a double unary in front of the cell references?
It's been working at my end. =--A2
Last edited by FlameRetired; 03-16-2015 at 01:40 AM.
@Ford
Did you get any thing ?
Hi there, pls see the file hope this work, Im make formula on column B, start on cell B2: =VALUE(A2) and formatted as date, and then you can copied down as necessary
Hi Azumi
It is fine in your attach sheet ,but while I am trying the same formula it is not working .so is there any hidden clause working behind it , then please let me know
Regards
Arindam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks