How do i format this time ?51556 (11/18/2009 12:37:37 PM) VICTORHi,
i have a column with times in this format, i.e.:
which respectively mean the follwoing times:
00 h: 04 min: 33 s
01 h: 04 min: 33 s
19 h: 04 min: 33 s
how can i s...
simple formula formatting question21242 (11/18/2009 10:24:15 PM) Cinci_ShawnHello,
My boss puts plus signs (+) in front of her cell references on
financial reporting. For example: a summing formula would look like
or when she adds two cells she'll precede the...
How to create a "dynamic" sql code11182 (11/18/2009 4:42:15 PM) andre_29Dear all,
I am trying to bring some data from ms access to ms excel and I need
to create a "dynamic" sql code .
I have a form in excel with 4 checkbox: so se user can select: entity,
extracting multiple rows of data from another worksheet12770 (11/19/2009 2:30:03 AM) JuneI have one worksheet, full of data. In another worksheet, I would like to search through the data individuals who belong to a certain group and then extract the entire row of information for that particular in...
Error Message When opening Excel14739 (11/16/2009 10:27:23 PM) HankLI am using Windows VISTA 64 bit O/S
with Office Professional 2003
All of a sudden I started to get the following error message:
'One of your object libraries (Stdole32.tlb) is missing or damaged. Please ...
Excel 2007 stops responding22254 (11/18/2009 3:40:04 PM) UtfOn several machines we have an issue that Excel 2007 stops responding when we
fill or drag cells or use the autosum function or change the number of
decimals of a selection of cells.
In the eventlog we s...
Excel licence message21312 (11/18/2009 10:41:26 AM) PaulDue to a system crash, I had to install Vista over my old XP, and
while I've reinstalled MS Excel (2003) OK, and activated it with no
problem, I still get the 'read/agree to licence' message every time I
Macro to take to last line and insert new row with number32050 (11/17/2009 5:36:06 AM) UtfHi all,
I'm looking to get a macro to take me to the last active row in column A and
then insert a new row, with the next number then appearing in the first cell
of the newly inserted row (for example c...
Upgrade to 200301310 (11/17/2009 11:04:07 PM) RobHi,
I have just been upgraded to Excel 2003 at work and everytime I start Excel,
I see a Book 1 file load and immediately close and then Book 2 opens and
remains open. I have checked both my XLStart dir...
Most Right Value in a Row21532 (11/17/2009 2:46:31 PM) SanCarlosCyclistIn another post, I was taught how to populate a cell with the last
value of a column. How do I populate a cell with the last value of a
selected row? I appreciate your help.
data lookup/validation syntax11812 (11/17/2009 4:14:11 PM) DougIn Excel 2007 I have a sheet "sheet1" which has a part number in a
I want cell (D5) to have a data validation drop down menu which is
populated from "sheet2".
Sheet2 data looks something like t...
Quick VBA Worksheet Change Event or Selection Question:11238 (11/17/2009 5:10:54 PM) Damil4real
Quick VBA Worksheet Change Event or Selection Question:
I have a workbook that has a sheet named "Formatted Prices". I enter
data starting from row 7 & from column A to S all the way down on a
Run Routine Automatically81381 (11/16/2009 7:17:55 PM) sswilcoxI've searched previous threads and have not found a solution.
Cell H40 contains the results of a calculation. If the value of H40 is
greater than 0.05 (5%), I want a message box to pop up to warn the
Chart of Times31319 (11/16/2009 6:48:33 PM) JimI am working with a simple data set comprised of two columns and 24
In column ("A"), I have the numbers 1-24. In column B, I have these
ActiveDocument.Variables / ActiveWorkbook.?12096 (11/16/2009 12:40:27 PM) VivienHi,
While trying to save a string in an Excel Workbook, but NOT in any
cell, I discovered something exists to do that in Word,
Is there a similar way to store data in Excel, ex...