Occasionally, I will paste from a table arrangement on a website.
Sometimes, this data will contain text that has some characteristics
of a date, eg, 3/16 as a fraction.
I could live with it becoming 0.1875, but not March 16, 2005.  How can

Does anyone know the NOW formula

I am taking an online college course in Elementary Algebra and need to post
my graphs online.  Can anyone simply explain to me how to graph linear
equations and inequalities.  I was informed that I can do this using Excel
but I have tried and tried and failed.................... ...

I have an application that writes a .SLK file for consumption by Excel.
It "works" in that Excel can open the SLK file and the
formatting/values are preserved. But Excel reports a whole series of
errors like "Cannot read record <number>".

Hi - I'm sure this is covered in some docs somewhere, but it's hard to
know what to search for.
I have a spreadsheet (using Excel 2003 SP1) in which I have a number of
rows that have an "ID" field taking the format "X.X.X.X" where X is a

Trying to create a monthly time sheet,
One column "H" as a fixed 8:00 using a "if" function referring to column "B"
so if a number is in "B6"  enter 8:00 in "H6" if not leave blank, this works
The problem then is column "H" will not auto sum at the bottom of the sheet?

I am trying to write a simple macro to lock all cells in all worksheets
for the Active Workbook.  The number of sheets in a Workbook can vary
from one to an undetermined number.
Here is what I thought would work but it doesn't.  It creates an error

I have spend few hours and I ave lost.
The problem is as follow:
I have pivot table grouped
Group I

Can I use cell references in criteria of the function countif?  Can I do
this using a boolean function?
Here's what I want:
=countif( A1:A100, and( >B1, < C1 ) )

I don't know if this can even be done in Excel, and if it can, I don't
have a clue on how to do it, so I am asking the experts.
I have a rather extensive workbook that I use to configure Project
Server settings.

Does any body know how to change or remove the TitlebarIcon from a
Excel Workbook.
In MSAccess you can do that in the menu> options>startup
In Excel, as far as I know, there's no feuture like the one in Access.

I regularly complete forms created by others which have merged cells.
Often, I'd like to get data to put into a cell from another
application via copy-paste.
I get the error:

i used subtotal with excel 2000 and everything was fine. now using exce
2003 i have some strange problems:
using the subtotals more then 2 times, the totals are not sorte
correctly and also the total isn't correct.

Hi;
1.  I've recently reviewed some articles and quite a few of threads dealing
with XL workbooks protection.  The general consensus appears to be: " ... XL
protection (using passwords) is a joke, and anyone with some knowledge of VBA