For years I have opened text files in Excel using the right-click
"Open With..." in Windows. The files opened without triggering the
Import Text Wizard and were imported in one column. As of yesterday
(without any apparent changes to Excel or Windows), this behavior

Before SP3 we renamed a text file to filename.xls and then executed
it  (done by an automatic process) which made excel open it up  with
all contents in the first column. It was then up to the user to do a
text to columns either by fixed size or delimited as they wanted.

I have a column A with dates and column B with data. I'm trying to create a
summary sheet. I use the max function on column B, which is easy, but I am
also trying to place the corresponding date (to the max value) on the summary
sheet as well. I've tried using the lookup function ...

I get alittle bit difficulties about how to arrange a program for a receiving
schoolfee payment, it means what formula should I apply for ?

WHEN TYPING IN A CELL A # THEY ARE APPEARING LIKE THIS 5.63663E+13
AFTER I PRESS ENTER- HOW DO I FIX THIS

"Jman" wrote: I need a macro that counts duplicates names only.

I consistently have trouble with Excel's print feature.  This is the most
recent example.
I'm working on a spreadsheet with many columns so I have set page breaks
from left to right.  At the time I did this, one page from top to bottom was

If I have a worksheet with multiple sheets, how do I set it to always
open sheet 1 when someone opens the file.  Thanks.
Bill - new member of the group
Boulder, CO

Column c may or may not have a date in each cell.
Column d may or may not have a date in each cell.
They will not have a date in corresponding cells at the same time.
If column c has a date then add 90 to that to equal column e

Does anyone have any suggestions on how to type text in combined cell?
For example, when I join A1 and A2 cells together, and enter a formula
If true, then type the text A at top and M at bottom, which looks like
following

I need a formula or a macro, that counts the total of visits of clients that
have come in more than once. All one visit clients i want them ignored.
Ex  in Column A "Client Names"  i have a thousand names.
John Dow

I have a macro that is listed below
It will be used for security  keep people from unauthorized use of my excel
file
Anyways. The macro listed below works gret. However I need to add

I have a macro that is listed below
It will be used for security  keep people from unauthorized use of my excel
file
Anyways. The macro listed below works gret. However I need to add

I have Excel 2007 and when I click on a file to open, it opens with just the
toolbar above but you cannot see any of the data.  When I minimize it, it
minimizes and then pops right back up with the data visible now.  Any ideas
how to fix that?

I'm working wiht Excel 2003 and trying to set up a form. I will allow
entries to be selected from a list - so far no problem. Is it possible to
format the entries in advance, i.e. that for example, if you selcet "name"
from the list, it will appear in red?