Hi,
Just convert it to real time and apply time format as well.
=--(LEFT(A1,2)&":"&RIGHT(A1,2))
---
Ms.Exl.Learner
---
On Tue, Nov 22, 2011 at 5:30 PM, jmothilal wrote:
> use this
>
> =LEFT(A1,2)&":"&RIGHT(A1,2)
>
> Mothilal.J
>
>
>
> On Tue, Nov 22, 20
Right click sheet tab>view code>insert this>change column 3 to suit
Now IF the length of the string is 4 and it’s a number, it will be
automatic.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Or Target.Column <> 3 Then Exit Sub
If IsNumeric(Target) And Len(Application.
use this
=LEFT(A1,2)&":"&RIGHT(A1,2)
Mothilal.J
On Tue, Nov 22, 2011 at 2:57 PM, hemant wrote:
> Hi all
>
> I am supposed to enter data in say "22:11" format in Excel 2007.
>
> Is there any method by which i will enter only "2211" and cell shows
> it as "22:11".
>
> Thus it will save my time
