Is there an Excel function I can use in a spreadsheet cell formula to
convert numbers surrounded by text to a number, for further manipulation.
Specifically  I want FUNCTION(E 0.384) = 0.384
The cells I want this to work on will all have "E " followed by a number.

I have created a spreadsheet which utilizes many of my own custom buil
macros and formulas.  Does anyone know whether or not my vba cod
and/or formulas can be copyrighted--ie legally protected?
thanks,

I'm getting an error message that says "A documents with the name " &
filename & " is already open"  (where filename is the actual name of the
file) when I try to open certain files in Excel 97, when I don't really have
a copy of the file in question opens.  This error comes up ...

Is there a global format that will change the same cell on
multiple sheets within the same worksheet, simultaneously?

I am developing an app with excel using VBA. I want to determine the type of
content of a cell ie, is it text, or numeric, or a formula, or a hyperlink.
How can I possibly do that?
Any methods, events, or functions to obtain this?

I post a question last asking how to do a  Workbook_BeforeSave
got the following ( slightly modified by me )
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

I am trying to write an IF formula that says
=IF(a1="*",1,0)
Where the * is absolutely anything (a number, text etc..)
I presume the formula is just looking for an asterisk within the cell but I

I need help with a macro.  I have a column of numbers
123.35
589.25
632.55

This must be elementary, but I am new to VBA. I have a SQL query that returns data to my sheet that is grouped by status, and ordered by date. Here is an example of what is returned:
9/27/2003 17:00    1    Open-Propose
9/27/2003 17:00    1    Open-Review
9/27/2003 17:00    31    Open

I have to use Excel 97.  I have downloaded information to a spredsheet with 3000+ records, some of which are duplicated.  I need to delete all duplicated entries, but cannot afford the time to tab down each record checking for duplicate entries.  Excel 2003 has a simple process, ...

In cell A1 I have a date. The date is not in text form but is
formatted as a date.
If the date is 7/4/04, I want cell B1 to say "The Fourth".  If A1 is
not 7/4/04, cell B1 should read "No  holiday".

how to change grade (A,B,C) to 4,3,2 score

I am looking for some help with a spreadsheet that was given to me, that needs to be reformatted based on the occurence of a substring within a cell.
Actually, the substring will be a keyword within a comments cell within a row.  Unfortunately the comments are arbitrarily entered ...

We had a power surge .I didn`t saved my excel file.Is
their a way to recover it .will appreciate any help
Garry

Is it possible to widen gridlines?
Even after changing the colour to black, they dont print out clearly on our
laser jet