Entering HH:MM
in [General]
|
Prev: how do i reconcile data in cells from old to new spreadsheet
Next: ActiveCell.FormulaR1C1 = "=SUM(R[-tellerteller]C:R[-1]C)"
From: JB Bates on 28 Sep 2009 18:01 Hi Don I am trying to do this same thing in windows Vista and when I do what you directed it does not work. If I enter 1300 in the cell it displays as 0000 and the formula lines shows "7/23/1903 12:00:00 AM" any thoughts? "Don Guillett" wrote: > Glad to help > > -- > Don Guillett > SalesAid Software > dguillett1(a)austin.rr.com > "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message > news:A64C8E57-4234-4007-8CF9-062D2C247DA3(a)microsoft.com... > > > > PERFECT!! > > > > Thank you so much, Don!! > > > > CaroleO > > "Don Guillett" wrote: > > > >> Preformat the column as time and try this. > >> Right click sheet tab>view code>insert this > >> > >> Private Sub Worksheet_Change(ByVal Target As Range) > >> If Target.Column <> 5 Then Exit Sub > >> Application.EnableEvents = False > >> Target = Left(Target, 2) & ":" & Right(Target, 2) > >> Application.EnableEvents = True > >> End Sub > >> > >> -- > >> Don Guillett > >> SalesAid Software > >> dguillett1(a)austin.rr.com > >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message > >> news:20247E05-1A67-4312-8C14-30745B9A351B(a)microsoft.com... > >> > Excel 2003 > >> > > >> > I have a co-worker who enters time on a spreadsheet. She would like to > >> > have > >> > the time cells fomatted so when she enters 1456 it appears in the cell > >> > as > >> > 14:56. This doesn't work when I format, cell, time, 13:30. I've > >> > looked > >> > at > >> > format, cell, special (which would be a logical place to put something > >> > like > >> > this), to no avail. > >> > > >> > TIA > >> > CaroleO > >> > >> > >
From: Gord Dibben on 28 Sep 2009 19:10 Did you place Don's code in the sheet module as directed? >> >> Right click sheet tab>view code>insert this Are you entering 1300 in a cell in column E? Any other column will not trigger the event. >> >> If Target.Column <> 5 Then Exit Sub Gord Dibben MS Excel MVP On Mon, 28 Sep 2009 15:01:02 -0700, JB Bates <JBBates(a)discussions.microsoft.com> wrote: >Hi Don > >I am trying to do this same thing in windows Vista and when I do what you >directed it does not work. If I enter 1300 in the cell it displays as 0000 >and the formula lines shows "7/23/1903 12:00:00 AM" any thoughts? > >"Don Guillett" wrote: > >> Glad to help >> >> -- >> Don Guillett >> SalesAid Software >> dguillett1(a)austin.rr.com >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message >> news:A64C8E57-4234-4007-8CF9-062D2C247DA3(a)microsoft.com... >> > >> > PERFECT!! >> > >> > Thank you so much, Don!! >> > >> > CaroleO >> > "Don Guillett" wrote: >> > >> >> Preformat the column as time and try this. >> >> Right click sheet tab>view code>insert this >> >> >> >> Private Sub Worksheet_Change(ByVal Target As Range) >> >> If Target.Column <> 5 Then Exit Sub >> >> Application.EnableEvents = False >> >> Target = Left(Target, 2) & ":" & Right(Target, 2) >> >> Application.EnableEvents = True >> >> End Sub >> >> >> >> -- >> >> Don Guillett >> >> SalesAid Software >> >> dguillett1(a)austin.rr.com >> >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message >> >> news:20247E05-1A67-4312-8C14-30745B9A351B(a)microsoft.com... >> >> > Excel 2003 >> >> > >> >> > I have a co-worker who enters time on a spreadsheet. She would like to >> >> > have >> >> > the time cells fomatted so when she enters 1456 it appears in the cell >> >> > as >> >> > 14:56. This doesn't work when I format, cell, time, 13:30. I've >> >> > looked >> >> > at >> >> > format, cell, special (which would be a logical place to put something >> >> > like >> >> > this), to no avail. >> >> > >> >> > TIA >> >> > CaroleO >> >> >> >> >> >>
From: JB Bates on 28 Sep 2009 19:43 Yes I did. and i even tried opening a new sheet with nothing in it and going through all these steps. still get the dame results "Gord Dibben" wrote: > Did you place Don's code in the sheet module as directed? > > >> >> Right click sheet tab>view code>insert this > > Are you entering 1300 in a cell in column E? Any other column will not > trigger the event. > > >> >> If Target.Column <> 5 Then Exit Sub > > > Gord Dibben MS Excel MVP > > > On Mon, 28 Sep 2009 15:01:02 -0700, JB Bates > <JBBates(a)discussions.microsoft.com> wrote: > > >Hi Don > > > >I am trying to do this same thing in windows Vista and when I do what you > >directed it does not work. If I enter 1300 in the cell it displays as 0000 > >and the formula lines shows "7/23/1903 12:00:00 AM" any thoughts? > > > >"Don Guillett" wrote: > > > >> Glad to help > >> > >> -- > >> Don Guillett > >> SalesAid Software > >> dguillett1(a)austin.rr.com > >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message > >> news:A64C8E57-4234-4007-8CF9-062D2C247DA3(a)microsoft.com... > >> > > >> > PERFECT!! > >> > > >> > Thank you so much, Don!! > >> > > >> > CaroleO > >> > "Don Guillett" wrote: > >> > > >> >> Preformat the column as time and try this. > >> >> Right click sheet tab>view code>insert this > >> >> > >> >> Private Sub Worksheet_Change(ByVal Target As Range) > >> >> If Target.Column <> 5 Then Exit Sub > >> >> Application.EnableEvents = False > >> >> Target = Left(Target, 2) & ":" & Right(Target, 2) > >> >> Application.EnableEvents = True > >> >> End Sub > >> >> > >> >> -- > >> >> Don Guillett > >> >> SalesAid Software > >> >> dguillett1(a)austin.rr.com > >> >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message > >> >> news:20247E05-1A67-4312-8C14-30745B9A351B(a)microsoft.com... > >> >> > Excel 2003 > >> >> > > >> >> > I have a co-worker who enters time on a spreadsheet. She would like to > >> >> > have > >> >> > the time cells fomatted so when she enters 1456 it appears in the cell > >> >> > as > >> >> > 14:56. This doesn't work when I format, cell, time, 13:30. I've > >> >> > looked > >> >> > at > >> >> > format, cell, special (which would be a logical place to put something > >> >> > like > >> >> > this), to no avail. > >> >> > > >> >> > TIA > >> >> > CaroleO > >> >> > >> >> > >> > >> > >
From: Gord Dibben on 29 Sep 2009 10:26 You mention Windows Vista. That is an operating system, which has nothing to do with Excel. What version of Excel or Office? I will assume 2007. Did you save the workbook as a macro-enabled workbook(*.xlsm)? Have you enabled macros when the workbook opens? Gord On Mon, 28 Sep 2009 16:43:01 -0700, JB Bates <JBBates(a)discussions.microsoft.com> wrote: >Yes I did. and i even tried opening a new sheet with nothing in it and going >through all these steps. still get the dame results > >"Gord Dibben" wrote: > >> Did you place Don's code in the sheet module as directed? >> >> >> >> Right click sheet tab>view code>insert this >> >> Are you entering 1300 in a cell in column E? Any other column will not >> trigger the event. >> >> >> >> If Target.Column <> 5 Then Exit Sub >> >> >> Gord Dibben MS Excel MVP >> >> >> On Mon, 28 Sep 2009 15:01:02 -0700, JB Bates >> <JBBates(a)discussions.microsoft.com> wrote: >> >> >Hi Don >> > >> >I am trying to do this same thing in windows Vista and when I do what you >> >directed it does not work. If I enter 1300 in the cell it displays as 0000 >> >and the formula lines shows "7/23/1903 12:00:00 AM" any thoughts? >> > >> >"Don Guillett" wrote: >> > >> >> Glad to help >> >> >> >> -- >> >> Don Guillett >> >> SalesAid Software >> >> dguillett1(a)austin.rr.com >> >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message >> >> news:A64C8E57-4234-4007-8CF9-062D2C247DA3(a)microsoft.com... >> >> > >> >> > PERFECT!! >> >> > >> >> > Thank you so much, Don!! >> >> > >> >> > CaroleO >> >> > "Don Guillett" wrote: >> >> > >> >> >> Preformat the column as time and try this. >> >> >> Right click sheet tab>view code>insert this >> >> >> >> >> >> Private Sub Worksheet_Change(ByVal Target As Range) >> >> >> If Target.Column <> 5 Then Exit Sub >> >> >> Application.EnableEvents = False >> >> >> Target = Left(Target, 2) & ":" & Right(Target, 2) >> >> >> Application.EnableEvents = True >> >> >> End Sub >> >> >> >> >> >> -- >> >> >> Don Guillett >> >> >> SalesAid Software >> >> >> dguillett1(a)austin.rr.com >> >> >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message >> >> >> news:20247E05-1A67-4312-8C14-30745B9A351B(a)microsoft.com... >> >> >> > Excel 2003 >> >> >> > >> >> >> > I have a co-worker who enters time on a spreadsheet. She would like to >> >> >> > have >> >> >> > the time cells fomatted so when she enters 1456 it appears in the cell >> >> >> > as >> >> >> > 14:56. This doesn't work when I format, cell, time, 13:30. I've >> >> >> > looked >> >> >> > at >> >> >> > format, cell, special (which would be a logical place to put something >> >> >> > like >> >> >> > this), to no avail. >> >> >> > >> >> >> > TIA >> >> >> > CaroleO >> >> >> >> >> >> >> >> >> >> >> >>
From: JB Bates on 5 Oct 2009 14:39
I thought being VISTA might be an important fact, sorry Yes Excel 2007 Yes saved as XLSM Yes Macros enabled. Still does not work. Is there another way to have it read with other than the code: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column <> 5 Then Exit Sub Application.EnableEvents = False Target = Left(Target, 2) & ":" & Right(Target, 2) Application.EnableEvents = True End Sub "Gord Dibben" wrote: > You mention Windows Vista. > > That is an operating system, which has nothing to do with Excel. > > What version of Excel or Office? > > I will assume 2007. > > Did you save the workbook as a macro-enabled workbook(*.xlsm)? > > Have you enabled macros when the workbook opens? > > > Gord > > On Mon, 28 Sep 2009 16:43:01 -0700, JB Bates > <JBBates(a)discussions.microsoft.com> wrote: > > >Yes I did. and i even tried opening a new sheet with nothing in it and going > >through all these steps. still get the dame results > > > >"Gord Dibben" wrote: > > > >> Did you place Don's code in the sheet module as directed? > >> > >> >> >> Right click sheet tab>view code>insert this > >> > >> Are you entering 1300 in a cell in column E? Any other column will not > >> trigger the event. > >> > >> >> >> If Target.Column <> 5 Then Exit Sub > >> > >> > >> Gord Dibben MS Excel MVP > >> > >> > >> On Mon, 28 Sep 2009 15:01:02 -0700, JB Bates > >> <JBBates(a)discussions.microsoft.com> wrote: > >> > >> >Hi Don > >> > > >> >I am trying to do this same thing in windows Vista and when I do what you > >> >directed it does not work. If I enter 1300 in the cell it displays as 0000 > >> >and the formula lines shows "7/23/1903 12:00:00 AM" any thoughts? > >> > > >> >"Don Guillett" wrote: > >> > > >> >> Glad to help > >> >> > >> >> -- > >> >> Don Guillett > >> >> SalesAid Software > >> >> dguillett1(a)austin.rr.com > >> >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message > >> >> news:A64C8E57-4234-4007-8CF9-062D2C247DA3(a)microsoft.com... > >> >> > > >> >> > PERFECT!! > >> >> > > >> >> > Thank you so much, Don!! > >> >> > > >> >> > CaroleO > >> >> > "Don Guillett" wrote: > >> >> > > >> >> >> Preformat the column as time and try this. > >> >> >> Right click sheet tab>view code>insert this > >> >> >> > >> >> >> Private Sub Worksheet_Change(ByVal Target As Range) > >> >> >> If Target.Column <> 5 Then Exit Sub > >> >> >> Application.EnableEvents = False > >> >> >> Target = Left(Target, 2) & ":" & Right(Target, 2) > >> >> >> Application.EnableEvents = True > >> >> >> End Sub > >> >> >> > >> >> >> -- > >> >> >> Don Guillett > >> >> >> SalesAid Software > >> >> >> dguillett1(a)austin.rr.com > >> >> >> "Carole O" <CaroleO(a)discussions.microsoft.com> wrote in message > >> >> >> news:20247E05-1A67-4312-8C14-30745B9A351B(a)microsoft.com... > >> >> >> > Excel 2003 > >> >> >> > > >> >> >> > I have a co-worker who enters time on a spreadsheet. She would like to > >> >> >> > have > >> >> >> > the time cells fomatted so when she enters 1456 it appears in the cell > >> >> >> > as > >> >> >> > 14:56. This doesn't work when I format, cell, time, 13:30. I've > >> >> >> > looked > >> >> >> > at > >> >> >> > format, cell, special (which would be a logical place to put something > >> >> >> > like > >> >> >> > this), to no avail. > >> >> >> > > >> >> >> > TIA > >> >> >> > CaroleO > >> >> >> > >> >> >> > >> >> > >> >> > >> > >> > > |