getsatv
05-26-2008, 01:34 AM
Hi Everyone,
I have Unique Problem in Excel Date formating i have excel file which is two date formats in it for ex m/d/yyyy h:mm(5/21/2008 7:43:00 PM), few cells show me this format 23/05/2008 07:42:13(General)in the same row. Iam not able to convert this in to m/d/yyyy h:mm i have tried change the format in many ways nothing worksouts.
Is there any Macro or any way where i can change the format 23/05/2008 07:42:13(General) to m/d/yyyy h:mm.
This would be great if anybody can get it done.
All the best
I have Unique Problem in Excel Date formating i have excel file which is two date formats in it for ex m/d/yyyy h:mm(5/21/2008 7:43:00 PM), few cells show me this format 23/05/2008 07:42:13(General)in the same row. Iam not able to convert this in to m/d/yyyy h:mm i have tried change the format in many ways nothing worksouts.
Is there any Macro or any way where i can change the format 23/05/2008 07:42:13(General) to m/d/yyyy h:mm.
This would be great if anybody can get it done.
All the best