I have a file with times in a column listed in military format, without a
colon, and in 15 minute intervals (115, 130, 145, 200, 215... 2100, 2115,
etc.).  I need only the hourly data so I need to filter out everything that
doesn't end in two zeros.  I've been trying to do this ...

i was reading another post and came accross the tool Ctrl Shift Enter. What
is this?
the following formula does not work if you enter it it in a cell and simply
hit enter, but if you press Ctrl Shift Enter, Excel puts {  } around the

I have a comstat workbook which has 52 worksheet tabs for all the weeks.  I
have it linked to a workbook tha has one column set up with the beginning
date we use for the weeks.  This workbook is formatted with custom mm-dd-yy
and it shows the month day and 07 for the year.  In my ...

I want to combine the data that is in 5 different cells into one cell. The
one cell that has all the information in it will be in the barcode format.
A1                     B1                   C1                     D1        
            E1

I'm building a spreadsheet where I'll need about a 100 or so checkboxes. I'm
wondering if there is an esieir way of "linking" them with the correct cell
(Most of the time they will be adjacent or the same ratio and, 2nd) if
there's an easier way of aligning (fitting) them into a ...

I have just started a new job and am using excel more and more (not an excel
expert).  Within Word I have created lots of macros some complicated VBA ones
and I want to recreate them in Excel (print macros etc).   I have just done a
simple macro and want to put it in a startup ...

I have a master spreadsheet that links to other spreadsheets with passwords.
I want to write the password in the formula that links to the other
spreadsheets in order to avoid entering the password manually each time when
prompt by excel for the passwords of my links.

How many times can I use the IF AND combination ina formula, is there a
maximum?
thanks!

Let's say I have a series of cells filled with different colors. Each cell
also contains a number used for sorting. (I've heard you can sort by color
alone, but we haven't gotten that far yet). Can anyone suggest a macro that
will "look at" the cell fill color, and format the ...

I have two columns with different info in each. I would like to combine the
entire column to make one. I noticed that in the help section, it allows me
to do this by cell, but i have 924 cells so I would prefer to do this by
columns.

I have a spreadsheet with a drop-down list box. I'm having issues that seem
to be compounded as indicated below...
•    The cell width for each column is very limited and the width of the items
in the cell work only with the font size of 8 or less.

Is there a maximum number of IF(AND's i can use in a formula or can it be as
many as required?

My company recently upgraded from 2000-2003 and the workbook that I created
that hyperlinked a database of files will not allow me to add or edit the
hyperlinks on each cell.  When I right click on a cell, existing or new, the
hyperlink tool function is not available. Nor is the ...

Hello  I created a user form in VBA . WHenever the workbook is opened I want
the form to show.  but I am having problems doing this.  Help! thanks

I know this question has been asked and answered many times over.  I just
need a little help understanding the finer points.  OK, Here goes.
I am attempting to find a way to calculate all of the possibilities of a
group/numbers givin certain restrictions.  I have found Myrna ...