i want to type in those charachters but instead of the symol appearing in the
cell, it highlights the menu options at the top (file, edit, fav, etc).  it
works if i type in the bar, or i type in the cell-delete- and then type
percent or fwd slash. Microsoft excel 2003

Is there anyway to keep this from happening?

I have the following code:
   On Error GoTo cont6:
   Cells.Find(What:="IP Trinity", After:=ActiveCell, LookIn:=xlFormulas, _
       LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _

I am trying to change the colour and display of a cell dependant on if a
date is within a range.  If the range is 24/12/2007:30/12/2007 in A1 and the
date displayed is 26/12/2007 in B1, how do i get it to state in C1 that the
date was within the range, green or not red.

Using Outlook 2003 & Excel 2003 on Windows XP Professional
I want to take the text from an email, copy it into Excel, into one cell per
line, displayed in full, with no delimiters.
I am using 'Paste Special - Text' to accomplish this, however, Excel is

Is it possible to show the data in the fomula bar and not the fomula without
protecting the sheet?
Thanks

I have sheet  "Sheet1" with a pivot table.I have defined a global
range name called "members". In pivot table range I used "members"
later I have copied this sheet. Its name became "sheet1(2)".
I have changed the data in the "members" range name. The range to

I would like to know how we can have a cell that returns the figures in words.
For example, you enter 25800 in a cell, the words "Twenty Five Thousand
Eight Hundred" should appear in another cell. This feature will help prepare
invoices that has to show the final invoice value in ...

When I enter the formulae =CONCATENATE(A2,B2)  or  =A2&B2 rather than joining
the two texts, the formula as such is visible. This happens even when I enter
the formula via "Insert Function" where the result of the combined text is
visible!

I have the following code:
   If ActiveCell = "IP Corporate" Then
   GoTo Corporate1
   Else

Moving Companies http://www.losangelesmovingservices.blogspot.com/

Furniture Boxes moving Los Angeles
GET FREE QUOTES from professional moving companies in your area
Licensed & Insurance
1. Long Distance Moving -Save on your Move

Dear Sir,
I am in seacrh of a formula. I want to fill up the cell of COST-TOm and
COST-Harry.
Product    COST-TOM  COST-Harry

I am trying to sort a column data. I have selected the data in a
column I want to sort. When I try to sort, the selection slips one row
down.
So If I want to sort then I have to select one more cell above the

I am writing a formula in cell "C1" in "Workbook #1" that will referenc
cell "D76" in a workbook that has not been created yet. The way I wil
tell the formula what the name of the workbook will be is b
referencing cell "A1" and adding the extension .xls to it.