WinXP, Excel 2003
Does anyone know a formula for this situation:  I type $1200 (annual LP gas)
in a cell and as soon as I leave the cell, the figure automatically changes
to $100 (monthly LP gas). I have many columns of figures where I have to

Hi,
So I want to write a function which divides every value in column A b
the corresponding value in column B and I don't feel like monkey typin
the formula in every cell. How can I apply this formula to all cells?

The function I am trying to figure out is this:
=IF(ISBLANK(E2),"",IF(N2<2,"Next" <here if N2 is <2  show contents
from cell G1>)))
I want to show contents from cell G1 to the above function, how do I

How do you change a word Document into a CSV Formated Document?

I want to make a sheet that allows people to enter data, but onc
entered, it cannot be changed.  Is this possible
--
km

I have a spreadsheet for insurance.
Min benefit in E1 is $10,000.00.
Max benefit in E2 is $90,000.00.
Wage Value is D6.

I've used Excel formulas in a basic way (sums, averages, divisions, and
multiplication of cell data) for about a year.
I came across this formula today for a project I need to complete. I've
never seen the "SUMIF" or the dollar symbol, OR the ampersand! After

Hi, and thanks in advane for the help!
I would like to know how to copy an existing worksheet and automatically
rename it from a cell within that sheet into the same workbook.  I have
searched but not found what I want to do.  I think it has to do with the

My company is in the process of converting over from Quattro Pro to Excel,
so I have a few newbie questions.
1. How do I set a default footer that is printed with every page of a
spreadsheet?  I want to have the path and filename, tab name, and date at

Dear Friends,
How can I use Vlookup to give me the closest value greather than or equal to
vlookup value.For example if my lookup value is 5 and I have 4.9 and 5.1,5.2
It chooses 5.1 and give me the corresponding value.

My apologies for a truly newbie question.  I want to know if there is
an Excel macro out there that has the same effect as the following
sequence of steps (for drawing a line graph)
1. Highlight Value (Y) axis data

I am preparing a spread sheet for calculating payplan for dealership
service advisors.
i have attached payplan in word and my spread sheet.
i need help with vlookup function to look up %ages from the tabl

I could sure use some advise.
I have a spreadsheet with information displayed like this:
Column A         B             C            D
company 1      red           200       pencil

I am using Excel 2002.  I would like to be able to print our timecards for
the month on one page.  Each timecard fills an entire page.  Is there a way
to fit all four timecards onto a single-page (one in each corner of the page)?

Hi to all
[Apologies if this post has already been attended to.
After posting the question, I could not download any headers and hence could
not see if my question was indeed posted (or answered).  I tried twice so it