04/11/05 is 2005/11/04 but Excel thinks it's 2004/11/05. I have many
this kind of date need to be correct. Anyone knows how to do it in the
simplest way? Thank you very much.

How do I make chart data labels appear in thousands, for example, 330
instead of 330,143?
Thanks

I found in older posts the following code to lock the scroll area:
(I have a workbook with only one sheet: Sheet1)
Sub Workbook_Open()
Worksheets(1).ScrollArea = "A1:N50"

I have an excell file which i want to be able to share, it has macros that
allow times to be added and saved. i was wondering if there was a way to make
this a file which cannot be altered, only info. added. like a template file,
to prevent deletion of the macros?

Apologies if this has been answered previously but I don't even know
what to search for!
If I type a long string into a cell (without wrap checked), the cell
contents will be displayed in full if the cell(s) to the right are

how many times can office excel 2007 be installed

If I input a number in A1, such as 1, and I have the following numbers
in B1 1,2,3 just like that separated by commas.
When I put that 1 in A1, since it matches a number in B1, can I then
have B1 automatically turn red? (or yellow or whatever)

I just installed Excel 2007 on Vista Ultimate.  About half the time when I
try to open Excel, it opens with no grid, no icons at all, no menus, nothing
except the word Ready in the upper left corner of a very thin colored bar
(not even a title bar).  I can't do anything with it ...

If I can chage it, Please reply...

How do you turn Auto-Save off so it stays off?  I go to tools>autosave
and uncheck it but it keeps popping back up.
Thanks

I was wondering if there was away to create a spreadsheet in excel,
for instance my HR girl creates a database of all personel with their
401k info then she has to save this in a .prn extension. we wrote the
Macro to name the file rename.prn. My question can we add to this

I have a formula to calculate amount of days from a hire date to current
date, but I would like to see the days to reflect amount of years and months
any assistance would be appreciated thanks!

Seems like:
    =IF(ISNUMBER(R8C15),IF(R8C15 > 0, R8C15/R1C17,Null),Null)
Should return Null if R8C15 contains "xxx".
But it returns "#NAME?" instead.

I have a valadation list set up in Excell 2000.  Is it possible to allow the
end user to edit one of the choices.  In the list I have the choice "OTHER"
and I would like them to be able to expand on that.  Thanks

I collect cash deposited(by customers and our cashier) into our account
online and post it to a shared workbook where others use the data.
Sometimes, I post cash received from customers(written in cash received list
sent to me) and then paid into the bank.