$$Excel-Macros$$ Re: Is there any way to make excel and access "understand" this time format

2011-02-08 Thread flebber
On Feb 5, 9:06 am, flebber wrote: > On Feb 3, 10:18 pm, flebber wrote: > > > > > I have a table of data containing name and time information. Excel and > > Access can understand it whilst it is in a format such as 12.2 or 11.8 > > but when it is in a minutes forma

$$Excel-Macros$$ Re: Is there any way to make excel and access "understand" this time format

2011-02-04 Thread flebber
On Feb 3, 10:18 pm, flebber wrote: > I have a table of data containing name and time information. Excel and > Access can understand it whilst it is in a format such as 12.2 or 11.8 > but when it is in a minutes format it cannot. > > For example I have a macro which I am still w

$$Excel-Macros$$ Is there any way to make excel and access "understand" this time format

2011-02-03 Thread flebber
I have a table of data containing name and time information. Excel and Access can understand it whilst it is in a format such as 12.2 or 11.8 but when it is in a minutes format it cannot. For example I have a macro which I am still working on which will tidy up an rtf to be a table recognisable an

Re: $$Excel-Macros$$ there has to be an easier way!

2011-01-16 Thread flebber
On Jan 16, 12:24 am, Vikas Chouhan wrote: > please provide data in excel.. > > > > On Sat, Jan 15, 2011 at 6:25 PM, herman gold wrote: > > a1 has IN, b1 has date, and c1 has time > > a2 has OUT, b2 has date, and c2 has time > > > > > On Jan 15, 12:49 am, Dave Bonallack wrote: > > > Hi, >

$$Excel-Macros$$ Remove selected cell contents

2010-07-27 Thread flebber
I have a column containing cells which house several delimited values and a dollar value. I want to be able to remove the delimited values and leave the dollar value in the cell in currency format. the cells contain information similar to 22-7-4-7 $22400.10 -- --

Re: $$Excel-Macros$$ Re: Please help - VBA book

2010-06-25 Thread flebber
I have the Excel VBA 2007 book by Mr Excel. It is a good book to get you up and running and it is good to reference back to. I still find using online resources and videos helpful as well. on the Mr Excel site you will find over 600 video podcasts(though video quality a little lacking) and a forum.

$$Excel-Macros$$ Listbox Named Entries - Defining ranges

2010-06-18 Thread flebber
Is there a way to define a listbox entry. So that the defined entry could represent an abitrary group of cells or a defined range? So say I create a defined range that has A3,A5, B2,B3,B4 and called it Group1. Could I in the listbox entry create a name say NewName that epresent the defined group