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!
11 9:35:23 AM
>Subject: $$Excel-Macros$$ How to change Date format in to number
>
>Hi Friends,
>
>
>I have change my cell which in the date format ex.MMDD or DDMM to
>original number i.e smiler to
>type date.I have attached the sheet in which Column A shows date format
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
Hi Friends,
I have change my cell which in the date format ex.MMDD or DDMM to
original number i.e smiler to
type date.I have attached the sheet in which Column A shows date format and
Column B is what i need to convert A in to B as a number.
Plz help.
Regards
Prabhu
--
---
