I would like to type in a cell in Excel a number, and be able to use a
formula in another cell to see its name string (e.g 250, converted to two
hundred and fifty)

Have the following, (used on multiple lines, in multiple workbooks)
Works great
=IF(D6="Alum",130,IF(D6="Rubber",145,0))
Need to expand it as follows:

I'm using the countif function and I need some help.
I have several rows of data but I don't want to use them all.
I have a problem though, because I can't arrange the data so
the rows I want are all together.  

There are lots of posts on multiple functions but haven't seen anything that
seems to address my issue.  I have a spreadsheet of variable length and I'm
trying to create a macro to automate getting out the needed data.  I think I
have the steps of the macro figured out except for ...

This could just be laziness, but with I dont want to do it for 3000 cells.
I work for a company where we can upload prices into our system that we use
with an excel spreadsheet. But the company who sends us the price list, has
dashes and spaces in their item numbers and our ...

I would appreciate some help with what I think is a form of lookup function
in Excel.
I have added two cells in a worksheet, One showing contractor name and one
next to it showing Contractor ID number. The data for both these cells needs

HI i've got a small peice of work which requires a spread sheet to show
a random value of 1, 3 or 0 but not 2 the formular i have so far is
=ROUND(RAND()*3,0) cana ny one direct me to my mistake as i am rather
amatuerish at excels functions.

I have the following Private Sub within my relevant sheet that I'm trying to
capitalise all values entered in a Range of cells, but it returns a syntax
error on entry, I guess its got to do with the way I've typed in the ranges
in the formula, can anyone assist?

Is there a function which allows me to count the cells which are shaded in
yellow ?

I need to know if there is a way to calculate only cells within a column
(column AL) that are a positive number.  The column has rows 3 through 1359
with quite a few that are negative numbers (these numbers are a result of a
formula) WE only want to include in the column total ...

I am trying to write a formula which has text and then a date which i
taken from a different sheet in the workbook.
EG the text is "Nav as at 31st March 06"
With 'Nav as at' being the text and the date 31st March being picked u

I'm using XL2003. For manufacturing purposes, products are stamped with a
serial number that includes the day of manufacture, represented by the day
number, i.e. January 1st = 001, 1st February = 032 and so on. Each new year
begins again at 001.

how can i do the following equation?
40$ if the sum is less than 1000$
75$ if the sum is less than 1001$ t0 3000$
100$ if the sum is less than 3001$

Can someone write me a couple of line of code?
3 cells to add 4th cell contains total
In cell c5 if a number from 1 to say 50 is entered then that number has a
value. The value being for instance 1 would be 50, 2 would be 49, 3 would be

Each month, we compile seminar information into a line item style excel
worksheet. Line items include type of seminar, number of attendees, number of
actions (blood pressure, body fat, cholesterol, sugar, etc..) taken with each
attendee, location and facilitator.  For the current ...