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
ic(Target) And Len(Application.Trim(Target)) = 4 Then _
Target.Value = Left(Target, 2) & ":" & Right(Target, 2)
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: hemant
Sent: Tuesday, November 22, 2011 3:27 AM
To: MS EXCEL AND VBA MACROS
Subject:
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
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 to enter ":" (Semicolon) frquently.
I am supposed to enter lot of data in this format and thus has to
enter ":" a