A1 is date of birth in 01/15/30 format. Need to show how old each person will be (years only) by end of 2010. Then need to indicate Y or N if they will be 65...

I'm trying to set up a spreadsheet where a have a picture (background) within the spreadsheet, but then I want to be able to type over the picture. I know you...

I am using Excel 2003 and I have upgraded from office 97. Before the upgrade the spreadsheets that we were using here at work updated without a problem. Since...

I am importing a text file with dates in the format 3/1/05. I need the data formatted as DD-MMM-YYYY. I can get this for all dates EXCEPT where the leading...

I have a workbook with several tabs and would like to have a value in the footer that is stored in a "control information" tab so don't have to enter it in the...

I have a spreadsheet that has 2 columns of date ranges. I want to refer to the first column and count how many entries meet a specific date range criteria. If...

I have a large spreadsheet of text data. The data has been manipulated through cut and paste from other cells etc (originally imported from microsoft word...

I created a template for a purchase order in Excel. Everytime someone opens the template, I would like one cell to be automatically numbered in a sequential...

How do I set passwords to protect just certain worksheets in a file?

I know you can reference a textbox to a cell, but is there a way to reference a textbox to a textbox?

How do I open an attachment in my e- mail with an XLS file, if I do not have Excel installed on my computer? My model is Windows XP Home.

-- Brian Jones Our Lady of the Sacred Heart College Bentleigh Victoria Australia

We have recently upgraded MSOffice97 to MSOffice2000. In Excel2000 I find that I cannot set the date format to the Australian date format, even though the...

I'd like to make numbers 0 green and numbers 0 red how do i do that? thanks

I'm doing this for a friend who has Office 2003. She is trying to get the office assistant to appear in her Excel file. She clicks on Help and then it prompts...

I am working with a workbook that has one worksheet only. I want all rows visible when the user opens the file. However, In cell B10, I have a drop-down list...

When I insert text into a box in the chart, if it overuns some of the text isnt displayed, how can I have it auto adjust to fit the text correctly. Another...

Is it possible within a worksheet to have cells containing numbers with "." decimals separation and other cells containing numbers with "," decimals separation?

Is there a simple way to Autosort a specific area on a work sheet. E.G. Column A Column B Column C 1) Salesman Items Sold Total $ Sales 2) ...