Outlook dont send mail
outlook is off line when my computer is online.

I am trying to remove the final character from a cell with a find and replace.
the cell contents are like the following example.
07APR07A
needing to be 07APR07

I am trying to greate a document that will tell me when someone needs
to renew thier training. I have 1, 2, 3, & 4 yearly training programs.
I want to  have a system where I can set conditional formating to goy
amber when it has been 10 months since the date and then Red when over

Using Excel 2002: SP2
Greetings,
I have not used Excel at any depth in for several years so I am rusty
with formulas, etc. I wish to set up a formula so that

If I use a calculator to compute sin 90¢X, the answer should be 1.
When I enter the formula =SIN(90) in Excel, the anwser is 0.894.
How can I get the answer of sin 90¢X in Excel?
Thanks in advance~~

If I use =B1/C1 to divide one time by another (eg. 76:12 by 43:23, where the
times are minutes:seconds) I get weird answers. If I reformat the cells with
[m]:ss, the formula doesn't work at all.
Any suggestions?

Hi. I have a large number of cells in a column, each of which
contains text. Some cells of text end in a period, some do not. Is
it possible to write a function that would add a period to the end
of each textbox?  I am not worried about corner cases, i.e., where

I want to use a user-defined function as part of a cell validation routine.
Is there a way from within the function to determine what cell is
being validated?
Does anyone have examples of something similar?

Whereas:
- Excel can (wonderfully) auto-resize a cell whose contents are wider
than its width.
- But auto-resize doesn't work on a cell that is merged with another.

Hello - I am trying to use the Match and index functions together.
Typically, I have been able to match and pull in the data without a
problem.
But now that I am using a text file that I export into excel, I am

I use Labels in Formulas extensively. (Excel 2003 11.5612.5606)
That is, I tick off Options/Calculations/"Accept Labels in Formulas"
and then use whatever text string I've placed at the top of a column
of data to refer to it.

I cannot see my horizontal scroll bar and excel sheet number(names).
Can anyone show me what I'm doing wrong?
Thanks
Ben

I am working in Excel 2002.  The postal address is in cell A1 with the
postcode.  I am looking to take the postcode out of the cell and put in new
cell and turn into CAPITAL letters.
1 The High Street London ln22 4tb

I type "The information gathered as of March 9, 2008" on cell "A1"
Is there a way to make a date default like
"The information gathered as of " & Date (default).
Your help would be much apprecated.

I need a macro to repeat rows 23 and 24 at top of each page. I must use page
set up to add rows 3 &4 so can't use it for rows 23 and 24 as well. Please
write macro as  I would use it, using rows 23 and rows 24 to repeat at top of
each page.