nde wrote:
> Hi,
>
> what is the significance of -- just before TEXT in the below formula. this
> formula works same even without --.
>
>
> *From:* Sixthsense
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Sun, 29 May, 2011 3:55:33 PM
> *Subject:* Re: $$Excel-Mac
Hi,
what is the significance of -- just before TEXT in the below formula. this
formula works same even without --.
>
>From: Sixthsense
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 3:55:33 PM
>Subject: Re: $$Excel-Macros$$ How to change Date format in to numb
Hi Prabhu,
Try the below formula in cell B2.
=IF(AND(ISNUMBER(A2),LEN(A2)=5),--TEXT(A2,"MMDD"),"")
Drag the B2 cell formula to the remaining cells of B Column based on the
Column-A data.
At the same time the same is provided in the attached excel for better
understanding.
Hope that helps!
Hi Prabhu,
just convert those dates into below format using below formula.
lets say in col A17 thr is date thn in col B17 type this formula.
=TEXT(A17,"mmdd")
A B
5/29/2011 20110529
>
>From: Prabhu
>To: excel-macros@googlegroups.com
>Sent: Sun, 29 May, 2011 9:35:23 AM
>Subject: $$E
Hi
Try
Sub Format()
Dim LR, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
Range("A" & i).Offset(0, 1).Value = Range("A" & i).Value
Range("A" & i).NumberFormat = "mmdd"
Range("A" & i).Offset(0, 1).NumberFormat = "mmdd"
Next i
End Sub
Thanks
Mahesh
On Sun, M
