I have 26:55:14 in time and I want to use a function to convert it capable of
calcuation (sum) Is this possible?

I have to track expiry dates in a datasheet.  Actually, I'd like the expiry
date field to change color 30 days prior to the expiry date written in the
field.  Let's say the expiry date is oct 24 2008, I want the field to change
color on sept 25 2008.  The date format chosen is ...

When I have a large text box (10 lines of wrapped text) excel shows a series
of # instead of the data.  This only occurs when I am outside the cell, when
inside the cell, the text displays correctly.  When viewing in Print Preview,
the # appear instead of the desired text.

I have an existing form in excel; and have added a combo box. now when
tabbing thru the form, it does not tab to the new combo box until end. need
to change order of fields; but do not know how to. any ideas

How can I inspect cells which contain data like...
2 weeks
1 day
3.2 hours

I have a problem using VLOOKUP - I dont get the expected result:
Using the following VLOOKUP: =VLOOKUP(C1;A1:B49;2) give me 700 instead of
the expected 100. Any help on that issue?
A                                              B              C

I'd like to have a macro that does this:
1) for cells in column F that is a) not empty & b) greater than 3000000,
search thru column K for the first empty cell. If there is, a message box to
be shown for the cell address. Then the whole macro should stop.

I am trying to format cells so that if the resultant % is >100% or <
100% then the cell displays *** Negative values need to be shown in
(%) rather than prefixed -
The following works with the exception that it will not display

Hi
I try to use vlookup to get values from another worksheet, but do not get
the expected values.
Formula used in Col I, Row 1319:

Does anybody know a web site where I can find a questionaire or test paper to
evaluate the level of some of my employees as I want to send them onto
various courses.  I also need the evaluation questionaire for Word and
PowerPoint.

hi community
how can i match data between two worksheet.....
example:
in worksheet A

Have tried to write in 3/5 and have it look like 03-May back, but excel
always comes back with 05-March! Have tried to format cells with both dates
and specials and also tried the "text to columns" but nothing works.
Anyone who can solve this problem?

I have a worksheet (not mine) which has filters.  When I filter I see the
result ( number of filtered rows) e.g., 11 of 336 rows - in the status bar.  
How do I get this feature in a spreadsheet I build from scratch?

I am trying to fill in a table that needs to look at two different columns to
see whether to to count the data.  For example, here is some data:
       A       B
1     10       3

I am importing data from ten spreadsheets into oe consolidated one. Five
work, the data appears in the new spreadsheet and updates fine - in the
others some cells (the ones with the most important data) return blank,
refreshing the data makes no difference. Yet where blank cells ...