I have a column that contains a number and a number enclosed in parenthesis,
is it possible to use the number that is enclosed for a calculation ie
c1=b1*a1"(#)"
Thanks

I have an ASP.NET (VB) routine that imports a lot of data from an Excel
spreadsheet
into a OleDbDataAdapter, and then into a database table.  The import
has been working fine until now, but my latest spreadsheet has a column

Is there a method (no macro) to prevent that when editing a cell it
cannot contains a null (blank) text?
I have tried with cell A1 inserting the following formula in Data
validation: "=(LEN(A1)>0)" but it does not work.

 I am trying to access/connect oracle database to insert and select data
from
tables. I don't know what to use like ADO? ADOX? ADODB? or others?
I was trying to connect using the following code:

I have a callout box on a rather complicated graph.  It really only has
value if it always points to the data point to which it refers. If I move
the end of the pointer over the data point, it looks exactly as I want it
to.  However of I move the graph on the screen, look at it ...

hi everybody......
if i have a query (i have one in a macro), everytime i open the file
the first thing that shows up is a dialog box asking me if i want t
"activate auto atualization" (i dunno the exact words due to my exce

How Do I insert a combo box into a cell of a worksheet?
SF

Is there an (easy) way to access those variables displayed using the
dos "set" command from an Excel Macro
Specifically want to target username, userdomain, homedrive.
Thanks

I am trying to get a sum value of time, trying to get it to input the
time only and calculate the total number of hours and minutes worked.
ie:
Start Time        11.05 (24 hour clock)

Hi, how do I extract the first names from the various cells? I hav
thousands so it is impossible to do it manually. Thanks in advance!
For example
A1 = John Waters. Should be John.

Say if i in a excel-file have this
=Book1!A8
This indicate colA row 8.
How can i change this to =Book1!Ax

I have tried to insert a logo into a spread sheet buut not a real pleasing
result.
First I scanned the image and then did an import into a spreadsheet but it
takes up the whle page  and I want to get it into a cell.

hello! i am sandy and i have not used excel for years and have forgotten most
of what i learned.  what i need to learn is how to set up a page or ? on how
to track how many times a phone number appears.  i would like to list the
date of the number also and sometimes the time.  i ...

I am trying to summarize in one cell, all the different shoe sizes worn
through the week. my spreadsheet looks like this
                        Mon   Tue   Wed   Thu   Fri
Shoe size worn     5        6      4        8      9

I have been trying to enter a date; however, excel keeps entering it as
the serial number. I have been searching for quite some time on how to
enter an invoice date - with no luck.
Does excel always recognize a date as a serial number.