Dear experts,
I have a data in which date format is Text, I want to change in date format
to filter data date and month wise. I have change manually this thing by
pressing FR and Enter key.
Please provide Macro or function to change the format, the example file is
attached herewith.
Regards.
Ashi
Hello
Pls change the date format and tell me solution
me manually nahi karsakta because 4500 customer same problem
Problem Yellow mark
find attach file
Thanks in advance
--
--
Some important links for excel users:
1
Dear experts,
I want to change date format from 20120121 or 21012012 to 21-Jan-2012,
because excel not count as an date format if I replace "-" or "/" character
between date,month and year. Is there any function to convert this type of
number in proper date format? Because this type of date genera
use this formula : CONCATENATE(DAY(C4),"-",MONTH(C4),"-",YEAR(C4))
On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara
wrote:
> Dear experts,
>
> I have a data in which date format is Text, I want to change in date
> format to filter data date and month wise. I have change manually this
> thing by
Select one column at a time containing data, then goto Data >> Text to
column (or just press Alt + D then E).
Select Fixed width & press Next 2 time, now select Date & existing date
format viz. DMY for Date-Month-Year and press finish.
Cheers!!
On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara
Oh Thanks to both of you, its very easy...Cheers!!
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya
wrote:
> see the attachment
>
>
> On Wed, Jul 16, 2014
Just run the macro or press ctrl+g,it will do the needful you required.
Regards,
C.G.kumar
On Mon, Nov 16, 2009 at 1:23 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello
> Pls change the date format and tell me solution
> me manually nahi karsakta because 4500 customer
Hi,
If you double click in the first cell, then press Enter, the cell is displayed
as you require.
You can either do this in each cell manually, or you can write a macro to do it
for you.
Regards - Dave.
Date: Tue, 24 Nov 2009 12:58:32 +0530
Subject: $$Excel-Macros$$ Change Date Format
From
ell is
> displayed as you require.
> You can either do this in each cell manually, or you can write a macro to
> do it for you.
> Regards - Dave.
>
> --
> Date: Tue, 24 Nov 2009 12:58:32 +0530
> Subject: $$Excel-Macros$$ Change Date Format
> From: nand
hi,
do as following
Select the column in which date is there, press ALT+D then E, convert text
to column will appear press next then next once again, select date option
then finish.
thanks
vir
2009/11/24 Nandkumar kakvipure
> Hello,
> Please Help me
> my system generate date format 14/10/09
Hello Pals,
I am very much grateful for the solution you all had provided for my
problem.
Thanks
Nandkumar
On Tue, Nov 24, 2009 at 12:58 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello,
> Please Help me
> my system generate date format 14/10/09 this type but i need 14 Oct
Hello
Please help me in giving the address of a good Excel and VBA tutorial around
Ghatkopar, Mumbai.
Thanks
Nandkumar
On Tue, Nov 24, 2009 at 12:58 PM, Nandkumar kakvipure <
nandkumar.hindust...@gmail.com> wrote:
> Hello,
> Please Help me
> my system generate date format 14/10/09 this type but
Hi Ashish,
use this formula (if you date format is same 20120121 )
*=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))*
On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara
wrote:
> Dear experts,
>
> I want to change date format from 20120121 or 21012012 to 21-Jan-2012,
> because ex
or try this one.. for any format
=TEXT(B2,"-00-00")+0
On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote:
> Hi Ashish,
>
> use this formula (if you date format is same 20120121 )
>
> *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))*
>
>
> On Sat, Jan 21, 2012 at 9:50 AM, As
try this
=TEXT(TEXT(B3,"-00-00"),"DD-MM-")
chandru
On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote:
> or try this one.. for any format
>
> =TEXT(B2,"-00-00")+0
>
>
> On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote:
>
>> Hi Ashish,
>>
>> use this formula (if you date format is sa
Thanks a lot for formula, could you please explain the means of "+0" in the
end of formula?
Thanks from Ashish.
On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran wrote:
>
> try this
>
> =TEXT(TEXT(B3,"-00-00"),"DD-MM-")
>
> chandru
>
>
>
> On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote
for convert to number format ... u also use ''--'' befor formula like
=--TEXT(B2,"-00-00")
On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara
wrote:
> Thanks a lot for formula, could you please explain the means of "+0" in
> the end of formula?
>
> Thanks from Ashish.
>
>
> On Sat, Jan 21, 2012
You can also use *1 befor formula like =-TEXT(B2,"-00-00")*1
On Sat, Jan 21, 2012 at 11:46 AM, xlstime wrote:
> for convert to number format ... u also use ''--'' befor formula like
> =--TEXT(B2,"-00-00")
>
>
> On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara <
> ashishbhalar...@gmail.co
18 matches
Mail list logo