Dear Suman,
Please use the below mentioned formula
Function put_date(input_your_date As String) As String
Dim splt
splt = Split(input_your_date, /)
put_date = Format(DateSerial(splt(2), splt(1), splt(0)), mm-dd-)
End Function
On Tue, Oct 11, 2011 at 6:38 PM, Suman ksuman1...@gmail.com
Hi Suman,
Attached file has the solution.
As the dates provided by you, were in Text format, hence I multiplied
them by 1 and then just changed the format in mm/dd/.
Let me know in case of any queries.
Regards,
DILIPandey
On 10/11/11, Suman ksuman1...@gmail.com wrote:
Hi,
Good evening to
try
=DATE(2000+VALUE(RIGHT(A2,2)),VALUE(MID(A2,4,2)),VALUE(LEFT(A2,2)))
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Suman
Sent: Tuesday, October 11, 2011 8:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Unable to change date fromate
Hi,
Good
Dear Suman,
if you interested to use VBA then you can use...
*Function Date_format(dt As Date)
Date_format = VBA.Format(dt, mm/dd/)
End Function
*
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
A simpler and more direct way would be to use Text To Columns by selecting
your date column, and in the column data format, select DMY and finish the
conversion. All your text dates would now be actual dates, and you don't
require use of any formula.
Alternatively, if you would like to use