LinkBack URL
About LinkBacks
Hi Guru's
I would like to change format of date. 10.07.2013 this is in DD.MM.YYYY but I want to change as MM/DD/YYYY.
Please help me for shortkeys of excel, even for rightclick button also.
Thanks in Advance Guru's
Regards
Uday
Hi Guru's
I would like to change format of date. 10.07.2013 this is in DD.MM.YYYY but I want to change as MM/DD/YYYY.
Please help me for shortkeys of excel, even for rightclick button also.
Thanks in Advance Guru's
Regards
Uday
I don't know if you would be able to achieve what you want with just a change of the cell format. If you have several dates that are in a column, you could use this formulain a column next to it and drag it down. Then copy the new column data and Paste Special Values over the original values.Formula:
Please Login or Register to view this content.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Originally Posted by Craig K.
I don't know if you would be able to achieve what you want with just a change of the cell format. If you have several dates that are in a column, you could use this formulain a column next to it and drag it down. Then copy the new column data and Paste Special Values over the original values.Formula:Please Login or Register to view this content.
Hi
I am able to subsitute . with / but also my goal is DD/MM/YYYY to MM/DD/YYYY. I have lot of columns like this to convert them.Examples
10.07.2013
10.07.2013
11.07.2013
31.07.2013
31.07.2013
22.07.2013
17.07.2013
10.07.2013
08.07.2013
24.07.2013
Regards
Uday
=date(right(a1,4),mid(a1,4,2),left(a1,2))
or
Data > Text to Column > Next > Next > Select: DMY > Finish out
Last edited by Teethless mama; 08-07-2013 at 02:26 PM.
Teethless mama,
Perfect! It is solved my problem. I am thankful to you.
Regards
Uday
You're Welcome!
Sorry, I didn't catch that part of your post. good thing Teethless showed up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks