I am cutting and pasting numbers which are in the format 1 - 0. Excel
insists on conveting some numbers into dates even when I tell it to
"use destination formating". Before I go and use a sledgehammer to
crack a nut by writing a formula to convert it back, is there a simple

how do i keep the zero on the price sheet using excel. $16.50

I am using comments exclusively as notes for individual cells in Excel 2000:
1)  I need to anchor each comment to its cell so it is in the same location
relative to the cell when I reedit it later.  Currently, when I add or delete
rows or columns, the comments for cells below and ...

I am using comments exclusively as notes for individual cells in Excel 2000:
1)  I need to anchor each comment to its cell so it is in the same location
relative to the cell when I reedit it later.  Currently, when I add or delete
rows or columns, the comments for cells below and ...

Does anyone know how to automatically copy cell above the current cell?
I have a long list of employees with account numbers.  However, I want
to only include employees with 6-xxxxx account numbers.  Having blank
cells on some of rows with account numbers, I may pull 6-xxxxx ...

Ran into an issue when using Auto filter.  copy cells in a col. from non seq.
rows, copy and then paste into a different col. and the data will paste in
seq rows and not as displayed on the screen.  pastes in the correct col.
incorrect row.

If I have the timestamp column with values like 10/16/2006 13:00:00 and
I want to subtract 14 hours.  What is the best way to do this using
excel?

=COUNTIF(E913:E914,"COR") is the formula I'm using to count the number of
times COR appears in column E.  Am I using this formula incorrectly?  What is
the correct formula to count a non number in a column if this is wrong??  
Thanks

Hi all,
Need some help.
One of my main data for my job, is in Excel format. The problem lies with
the cell format. All number being stored as text. I need to do error checking

I am looking to integrate Excel and a back end MS SQL Server database.
The database is running on MS SQL server and has statistical information
for help desk agent call stats.  I want to create a spreadsheet that can query
the database and provide certain information about agent ...

When I asked the following on the 5th:-
Is there a way of permanently arranging in col. H that the result of  the
amount in col. D plus amount in col.E less the amount in col.F is
automatically shown once the entries in cols. D, E & F have been made.

I wish the page field of the PivotTable is more user friendly.  In order to select multiple items, I hide the items that I don't want and then select (all) to get the multiple items.  I am wondering if there is an easier way to *unhide* when I am done.  Currently, I drag the page ...

I just finished a spreadsheet last night that was opened from a flash/jump
drive and saved back on it after editing.  I took the drive to work and now
it is saying that is a unable to read file.  So I brought the drive back home
and it still won't open--saving unable to read file ...

My computer crashed and burned a couple of weeks ago and it contained a
very important spreadsheet on my hard drive.  The computer was
spontaneously restarting every minute or so and because of this I was
having a hard time getting files saved on CD or floppy disc.  I managed

I do a lot of conversions of different types most frequently involving
measurements, for example from square meters to square feet, gallons to
cubic feet, etc (sometimes involving unusual measures such as Chinese mu, a
measure of area).  Are there any functions or routines to do ...