I have several dates listed as mm/dd/yyyy.  How do I remove the year
automaticall from a long list?  I do not mean that I want to format the cell
to just show me the month and day, I want to actually remove the year data
from the column not just hide it. Thank you.

Where apostrophes ( ' ) appears in a  string can it be removed with a
formula?

I am trying to figure out a way to reference a value from one sheet t
another.  I know how to go to sheet 2 and "receive" a value from shee
1 (=sheet1!a1), but I don't know how to take a value from sheet1 an
"send" it to sheet 2 (??).

undefined
I am trying to create a worksheet to calculate the worked hours daily
It formulates it that I have managed to do that but approaches whic
desire the result gives it in hours. When I turn to him the hours i

I have a table of product and prices and i want to create a drop down list to
select product with a formulae in another cell that returns the relevant
retail price dependant on the product selected from the drop down list, with
another cell returning the cost price

What i do here wrong, its not working.
=IF(C7<=9;(10-C7)*47/100*1000;"Nothing";IF(C7>=11;"HELP"))
=IF(C7<=9;(10-C7)*47/100*1000;"Nothing")  <-- this is working.
Help

I would like to have a user type in just one letter and return a specific
word for it.  For example, if a user types in the letter "c" I would like
"CDN$" to be displayed.
Any ideas?

1. COLUNM A= IS THE QUANITY, COLUMN G= IS THE PRICE, COLUMN H=IS THE TOTAL -
ALL THE WAY DOWN.
2. EXAMPLE= 1O CHAIRS @ $2.00 = $20.00
THUS, WHAT WOULD BE THE FORMULA FOR THIS TO BE REPEATED IN THESE COLUMNS

Hello from Steved
in Cells A1 to F1 I have
25, 2, 3, 12, 23, 1
ok in cells H1 to M1 Iwould like to have

How can I set up a serial number cell such as an invoice number that
automatically increases by one each time I need a new invoice?

I am really puzzled. Could someone help, please?
I am using a lookup table, where I have had to use concatenate to merg
three cells into one. I have then copied the fomula down to all othe
cells

I'm trying to return the contents of a cell located above a cell returned
from the "small" function...into the  cell located next to the cell which
contains the "small" function....help!

I need an if formula like
b1=if(a1="14,50","10,50",if(a1="14,00","10,00",if(a1="13,50","18","0")))
but this formula does not work.
can anybody help me?

I have 3 columes of numbers x y z GPS location and depth. Many of the numbers
are repeate numbers and I want to delete the repeate numbers. How can I do
this

I have an ACCESS database that I copied over into EXCEL for ease.  Now I have
a date such as 04/08/2005.  I'd like to somehow add a column for the day of
the week that this is, or add the day to this particular column and I'll use
a delimiter or something to separate it.  In the ...