We just copy and paste data from MS Access 2003 to Excel 2003.
When we save the Excel as CSV file, we find that the date has been converted
to American format.  We have checked the Regional Settings and Australia is
used.  Is there any language setting in Excel ?

There may not be a way to do this and I can't find any documentation on
it.....
I want to vary the row number in a cell reference.  For example, in one
sheet of a workbook I refer to a cell in another sheet in the same workbook.

I am creating a planner and I have entered in all kinds of data but I now
want to change the orientation by rotating the entire sheet counter clockwise
and then rotate the text clockwise to be readable.
I can only find how to rotate the text/data but not the sheet. I'm running

Hi need help with this simple task.
3 cells A1 A2 & A3,
if cell a2 has the number 1 in it I need cell A1 to display yes,
if cell a3 has the number 1 in it I need cell A1 to display no,

I see you can group pivot tables by month, year, quarter, etc..
What happen to 'by week'?
Thanks.

I just bought an upgrade version, the package says that if i have works 6-10
this version will work for me. The sales clerk said I would need to buy the
full version. Anyone know aabout this.

I've made come custom headers and footers, and they show up in the
print preview just fine.  But how do I make them show up in the
regular spreadsheet view?  My users won't always be printing these
spreadsheets, and they need to be able to see the header and footer

how do i automatically run a macro when i move from one worksheet to another.
ie select another worksheet, then automatically run a specific macro
pat

I have a pivot table with data from cell B9 to cell S33. I want to add a few
lines at the bottom (not as part of the pivot table), which subtract the
figures in some of the rows to give a net total.
I have just moved from XL2000 to XL2003, and this has caused a problem.

How to resolve this:
I think I need to implement SumIf here but not clear how, here is what I
need to do:
Sheet1:

I am looking for a good template for inventory management and control.
Does any one have one?
Please email me at chirantan.chanana@gmail.com
Regards,

Can Excel 2003 be set up, without VBA, to do Data Validation from a range of
cells so that if the person type in the first few letters of the range the
pointer moves down the list to those cells to start the selection process?
Example of "la" moves to Lanata and doesn't start at ...

I have a column (A1:A10) of sheet names (sheet2, sheet3, etc) on
sheet1. I want to put in column (B1:B10)  of sheet1 values from each
sheet on the workbook named in column A from say cell H1.  Is there an
easy way write a formula and copy / paste?  I can hard wiring it; but

would somebody please tell me how to change the defaut calculation setting
inside options to automatic from manual?
I can't have this change be permanent, I would like that everytime I open a
workbook the setting is defaulted to calculate= automatic.

I'm not good with macros, so if we could do this simply, I would
appreciate it.
Spreadsheet 1
I have a list of all my accounts