I am trying to enter data, such as name, street address, city, for example
in a single cell, each item to appear on a single line, hopefully indexed
to, again for example, the left.
After formatting the cell to wrap text, you can do this by typing each line

My computer is set up to use the European style dates (ddmmyyyy), not the
USA-style dates (mmddyyyy format). So if I enter "01/06/05" I get a date of
01-June-2005. However when I download some information in CSV format at
times that same date is formatted like this: "06/01/05". ...

Is it easily doable to have the subtotals from sheet 1 calculate (show?) on
sheet 2? I have used the Data->Subtotals to get what I want on the sheet but
when I want to copy only the subtotals to another sheet, I get all the
cells. I have been exporting the info to Access and then ...

Question:
Is there a formula (function) which will tell me the end of th
worksheet.
Assume I have a worksheet whose last row and column is: "M55" (colum

I need to get data from a web site.
I can, either, click > drag > copy the web site table and then paste
into Excel
OR

 I wonder if anyone could help me  with the following problem and how I can
sort it out
 I have a mailing database on a floppy disc which I need to transfer onto
A4 size sticky labels to send out a mailing list

I have several thousand records where there is a column for middle
initials.
Every so often the middle initial does not have a period.
Is there a way I can find those cells (or maybe highlight them), so I

 I have 2 Excel files in Server. C17 is the Cell No. in Both the sheets are
linked. (i.e) for example i have the 2 excel files named A & B. if any
changes have done in the A.xls in C17 cell then the B.xls C17 will have the
same data & Vice Versa. Its working fine in the server ...

On opening an Excel 2002 document, I do not get the actual text in column
names or values. For example Name is showing as #NAME? and not "Kevin
Depeter".

I have a workbook that has about 20-30 worksheets in it. There is one column
in every worksheet that has a total, is there a way to have all the totals
from the worksheets show up on one worksheet as a grand total.
Thanks in advance

I would like a cell to have a background color of yellow if it is empty (ie:
neeeds data input). Once it has data, the background turns off. I used two
conditions in the conditional format command and it doesn't appear to be
working. I used

I am trying to learn about Macros because our head financial guy is a boob
and has everything screwed up.
Here is what I am trying to do:
1. I have a list of main data in a spreadsheet on one worksheet

Does anyone know how I can unhide a worksheet? I have about 15 worksheets
that have been hidden and when I try and unhide the worksheet it is greyed
out ... not sure how to do this.
TIA

   There are two sheets X and Y in my workbook. On A, there are hundreds of
ranges named locally (i.e. names are like "X!students"). How to write a
macro to name the respective areas in Y with the same local name? For
example, if X!$A$1:$B$4 is named as "X!students", then I want ...

the month function gives me 1 for the value of month(today()), can i get
january instead?
thanks.
jim