My formula calculating is very slow, formula is as under & my active cell is
E5 !
E5    12345
J5    =IF($E5="","",IF(ISNA(VLOOKUP($E5,sl,11,)),"",VLOOKUP($E5,sl,11,)))

Can I input in a cell:
Create tablespace $A1 datafile '$B1' size $C1 REUSE.
and expect  the result to be ==>
Create tablespace TS_TEMP datafile '/opt/oradata_sid/temp.bdf' size 799M

I need to use a function to add a hidden apostrophe to a cell. For
example, the cell has 2021 and needs to have '2021 with the ' hidden.
Does anyone know a function that can do that? Any help is appreciated.
Thanks.

I have a command button in my workbook that will automatically email the file
to some designated recipients.
How can I make the email Blind Copy 2 of the recipients?
Currently every recipient shows up in the "TO" section.

I have employees that open up five monthly reports each night after midnight
numbers are collected for the day.  The reports names have the format of
yy-mmrpt.xls.  So for example two reports for Jan '08 would be 08-01tss.xls
and 08-01po4.xls. We have reports dating back to 2001.

Hello, I'm looking for an Excel macro function reference library for Excel
2003, I believe it was version 4.0
I had a manual with this information but seem to have misplaced it, If
anybody knows of a place I can find this information I'd appreciate it.

I need to show the content of a specific cell in the custom page header when
I print my worksheet.
I'm sure it can be done because I did it way back in Excel 95 or 97, but I
can't find the right search term to locate it in the help, and the wizard

I have a spreadsheet with approximately 6,000 lines.  Each line represents
one participant.  There are 231 columns.  There are 7 quarters of information
with 22 columns for each quarter strung over the columns, along with some one
time info.  The re-organized data needs to have ...

I have a file that I regularly download from a mainframe system.  In the
file, dates come across as numbers in a MMDDYY format (example, May 31, 2007
come across as 53107; November 15, 2007 is 111507).
How can I change these numbers to a correct date format in Excel?

 First of all I don't know Excel very well, I know just the basics so
please keep that in mind when making any suggestions.
I download my credit card data in csv format every month, I would like to
have a spreadsheet that would keep track of the money I spend and show me

I have a shared workbook in Excel 2007 (and it needs to stay in 2007) and the
rest of our staff that would simply need to view it are in Excel 2003 still.  
Is there a user-requested report that can be created in 2003 to pull from the
shared workbook?  Or any other ideas?

I am trying to copy cells from one sheet to another and I would like to bring
the color of the cell over as well.  It also always brings over a 0 if I
don't have any data in the cell.  How can I just bring over the color of the
cell without the 0?

How can I make several copies of the same worksheet at the same time?
Excel 2003
tiger21

I have an excel sheet that i use all the time and all the sudden the
text is not viewable.
If i highlight it, then it i viewable in the fx box.  I can type in
and it will show up as I edit, but dissapear afterwards.

I have a spreadsheet where I'm using G1 as $Amt, H1 at 20% less of G1,  
=sum(G1*0.2).  In most cases after adding the formula the cell shows 0.00,
but in some cells it shows  #VALUE!.  This would not be a problem except I am
also doing a sum total of each column.  The $ amount ...