One best and quickest way to convert a string based d/m/y format to a date
based m/d/ is by using the text to column feature in excel.
How to do it?
Select the Text to Column wizard, click on Delimited, Next twice, and now
in the column data format, select d/m/y and click on Finish. That woul
Hi krishnanm,
Here are some other formulas... these will interpret the date using your
computer's regional settings, same as if you typed the date in yourself:
=DATEVALUE(B1)
or
=--B1
The trick in the second example is using any arithmetic operation with a
neutral effect. It forces Excel to con
Gr8..
On Nov 25, 10:51 am, NOORAIN ANSARI wrote:
> Dear Krishnann,
>
> Press Ctrl+shift+#
>
> or use
> =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/")
>
>
>
>
>
>
>
>
>
> On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> > All,
>
> > Is there a formula which converts text to date?
>
> > PFA the sample file w
Gr8..
NOORAIN ANSARI wrote:
> Dear Krishnann,
>
> Press Ctrl+shift+#
>
> or use
> =TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/")
>
> On Fri, Nov 25, 2011 at 11:18 AM, wrote:
>
> > All,
> >
> > Is there a formula which converts text to date?
> >
> > PFA the sample file which I am trying to convert..
>
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert text to date using formula...
Hi,
Just convert the cell to date format
Thanks
N.Sundarvelan
9600160150
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file wh
Awesome... Thanks buddy :)
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Fri, 25 Nov 2011 11:21:04
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Convert text to date using formula
Hi,
Just convert the cell to date format
Thanks
N.Sundarvelan
9600160150
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file which I am trying to convert..
>
> Thanks in advance
>
> Best regards!
>
> --
> FORUM RULES (934
Dear Krishnann,
Press Ctrl+shift+#
or use
=TEXT(VLOOKUP(A6,A1:B4,2,0),"dd/mm/")
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file which I am trying to convert..
>
> Thanks in advance
>
> Best regards!
>
> --
> FORUM
