I would like excel to automaticly generate ordinals for me, actualy
autofill..
in format:
1.

Every so often the date format for all open worksheets are changed from yyyy
to yy for no apparent reason.  This can be resolved by closing down and
re-starting Excel so it's no worse than an irritation.
Does anyone know why this should happen please?

When I open reports in excel, I often see numbers that read 1.00043E
+11, apparently indicating that there is a number format problem.
When I change the cell format (to text or number), I am usually able
to see the full value in the cell.  However, I must first physically

Need help on how to copy linked cells into another file and keep the
links. I have several files which have links in them, need to combine
all into one file so we can autofilter through all entries. When I
copy over the data and paste, the link does not come with it. Tried

I am trying to graph a set of data in 'XY (Scatter)' and am running
into a problem I've never seen before.
There are only seven values for 'X' - numbers 0 through 6.
'Y' is a set of percentages ranging from '0.00%' to '13.00%'

I have an IF formula in a merged cell (XL 2003):
=IF(SUM(AO6:AO13))=AB13,"","Error!!  Daily Miles Totals Do Not Equal
Daily Route Totals!!"
The merged cell is formatted as Text, Word Wrap on.

Gurus,
Running Excel 2003.  I pasted a graphic from a Word document onto an
existing Excel spreadsheet, but when I go into "Print View" or actually
print out the page, the graphic is not visible.  What am I doing wrong?

I have only been using Excel for about 4 months and in the process of
learning new things.  I want to make use of macros to automate the
repetitive tasks I do every day, but just when I think I've mastered
each one, I get error messages.

I have a list of which an example is below, that I need to sort by the
date then the time.
This information is in 1 (each) cell. 3-26-Wed - 6:00 PM - Company -
Alhambra Dinner Theater - Jax - 641-1212

how to conditional format a n*m box depending a column value
for example I have 4*3 box and I want to highlight the row depenidng the
third column value.
a,f,3

I have a wierd problem: in a planning module it should be possible to
choose the correct product in a validated list.
There is a matrix that shows only those articles that can be planned
on a specific machines.

example of what i want to do: take a number from F1 and add it to D2 and then
have the sum placed in F2.  i want to set it up to continue to do this for
every new number entered in column D it will then place the new total in
column F.   Help!!!!!

Is there a way to e-mail just one sheet in a workbook that contains multiple
sheets?
Thanks,
Debra Lassman

I pasted in a table from a web page.  Wanted to to work with the numbers in
the web table, in Excel.  Fine!  But, it turns out there were also a bunch
of little objects in the web page.  Totally small, a few pixels i think.
You don't even see them on the sheet, but i noticed them ...

This site has been experiencing problems for a few days, but
(fingers-crossed), it seems to be back up and running now.