I have a column of numbers with 2 decimal places (monetary amounts).  If copy
and paste into excel, it converts them to text.  If I import the text as a
text file, excel converts it to text.  If I open the text file (which has a
column of numbers and nothing else), excel converts ...

I have a very important workwook in Excel 2007 - and therefore ensure that
it automatically creates a backup of the file itself when it saves.
Just now I tried to save as usual and it told me there was a problem - a
couple of dialogue boxes later it told me that the file was so ...

I have a file that will be distributed to about 400 people that
displays data that they will need to filter and print out.  The
worksheet contains about 36000 records. I am using an autofilter, but
my problem is that the autofilter takes about 3 seconds to apply, but

I am trying to write a formula that will look at todays date and if it
falls in July to return a 1, if it falls within August to return a 2,
if it falls within September a 3, October a 4, November a 5, December
a 6, January a 7, February an 8, March a 9, April a 10, May an 11 and

I've used Excel 2003 to create a matrix of Medicare & Medicare Supplement
Plans containing comments in selected cells. I've lettered and numbered the
columns and lines to aid finding cells quickly when speaking to others. When
I place the document in Print Preview, I see that ...

I would like to have a close out date entered then when entered
If the date is 30 days or more from the current date the closeout
block becomes red behind the date
If the date is 90 days or more from the current date the closeout

I want to copy a worksheet from one workbook to another.
But I do not want to copy the named ranges associated with the first
workbook to the second.
How do I prevent named ranges being copied when I move sheets.

Is any one able to help me figure out what I'm doing wrong?
When I do a sumproduct on a closed workbook for the exact number of
rows it works, but when I re-write the formula to include even one
additional row (1 row of blank data) it will give me a #REF! error

I have a simple sum that calculates the difference in between the
start time and end time.  But, what I don't know how to do is put in
an If statement that says If the difference is greater than 7,
subract :30.  Now, if I havr to do this as decimals, that is fine but

[<-1000]-##0E+0;[<=-1]-##0;[<0]-##0E+0;[=0]0;[<1]##0E+0;[<1000]##0;##0E
+0
After my eyes and braind went blind trying to debug the above format,
I decide to ask around...

I have been using Excel 2007 to import comma delimited text (csv) files
stored on my local hard disk into my personal finance spreadsheet. The
Data>Get External Data>From Text wizard works fine and have had no trouble
using the Refresh function. The problem comes from accessing a ...

Whenever I open Excel I get 2 blank new sheets, Book1 & Book2.  If I leave
Personal.XLS unhidden, I get only Book1.  Am I goofy or what?
Thanks
John

When I clear a highlighted cell, the gray grid lines disappear.  How do I get
them back?  I am using Microsoft Office Professional 2003.

I have chart which plots sales income (y axes) vs months (x axes) over the
past 10 years. The chart already contains two trend lines which begin at the
origin.
I want to add a new trend line to the existing chart beginning in 2005 to