So, I have a worksheet with data pasted in from a Database. I have, for
instance, a column that is all numbers stored as text. I'd like to
convert all the cells at the same time. OR, I would like excel to
ignore the error for all of them.

I'm using the Beta release of Excel '07. When I try close the program using
the close button (red x at top right), it simply closes the current workbook
and not the program. To shut down it down completely, I have to close all
workbooks and then finally close the program. Is ...

I have a spreadsheet that in column A= seconds. I want to take the
seconds in col a and convert to minutes in col B, then in col C convert to
hours and in col D convert to days - this is the formula that was given to me
yesterday.

Trying to paste a few lines of text from Word into a single cell in Excel and
it pastes onto several rows.
How do I make it paste into a single cell ?
thanks

i have a long page with date and i want the first 2 columns to follow if i go
to the right, so i still know what's opposite that cell.
Do yopu understand my question :-)

I'm trying to import data from an Excel datasheet to Microsoft SQL
server 2003 using the import wizard, but I'm having trouble with one
data column. When a cell has a value of, for example,
E4/E20, the slash character seems to pose a problem. I have tried

I have got golf scoring spreadsheet.  (gross, net and stableford)
I've got it nicely sorted out for overall scoring, but now want to have 4
seperate result tables, depending on what grade the player is in - so
therefore, i want the spreadsheet to automaticaaly enter all the grade ...

In the Data Analysis add in there's two t-tests: one for samples with equal
variance and one with unequal variance- how do you test to see if the
variances are equal or unequal using excel and therefore choose the right
t-test?

I have Microsoft Office Pro 2000, SP-3.  I have several Excel spreadsheets
stored on my desktop.  Today all my icons disappeared.  The files seem intact
and the outline of the original icon remains, but it is blacked out.  What is
causing this and how do I fix it?  Nothing has ...

I have a table with various fields of information in each cell.
one column has a list of names, these are repeated randomly throughout the
column.
i want to creat a chart from information relating to each name. So I need to

Hi
I have a vertical list of 6 digit codes and wish to copy turn them into a
horizontal list in a single cell. Each code is prefixed by '.
thanks

We are a small business and do our costings on an excel spreadsheet. We have
a list of ingredients with costs and these are matched up with quantity to
work out total costs. We have 200+ recipes and this is very messy -
especially if ingredient prices change. If we use a data ...

I have a huge excel sheet being shared over the network the problem is that
when i run vlookup and save the file the file size goes very big. also the
data is really huge in these and its really inconvenient to run vlookup again
and again. i want to automate the process that when ...

Can anyone helps me with a problem I have got?
I have a column of cells with data in e.g.
123 apple
4390 banana

I used to have a tab labeled security when I clicked on properties of any
document.  It has disappeared.  I have disabled the simple sharing and still
no luck.