I know I can use month(ref) to get the month number, but is there a function to return the month name? i.e. function(2) = February?
I know I can format the cell as "mmmm" to just display the month on its own, but I need to incorporate it into a string on other text.

When I run subtotals on a set of data, it's obviously not that flexible
in what it will display for the subtotals themselves.  For instance, I
have a three column worksheet where the first column has a product #,
the second column has a description and the third column has a

Like RickyDee, I am trying to figure out how to have a
cell change color automatically.  But I dont' think he's
on the same track as I am.
I'll write it out in 'long hand'.

How can I do the following I have five columns
Col 1 Mileage counter start
Col 2 Mileage counter end
Col 3 Mileage done (total from start to end column )

Office XP
I've imported a list of contacts from Outlook, and
there's a ' in front of every cell with data, although
it's not visible in the spreadsheet. Only in the Formula

how do i get the vlookup formula to return 0 or return
nothing instead of #n/a. i know it has something to do
with a vlookup formula nested in an "if"
statement...please advise...

Have worksheet that is wide and long. Wish to pan across
and down worksheet, while retaining the top row (titles)
and left column (case numbers) on the monitor.
I have done this before, but gee, I just forgot how to do

i am working on a worksheet that i want to have a running
total, the only problem is that i have one cell that will
a number and change to another number, i can't find a way
to capture the previous number.  for example i have cell

Like so many others that have posted in the last two days,
my question is about counting and conditions.  I've read
the responses and read the help files but am not able to
understand enough to apply the info to my problem.

is there a way to say, put in the formula =today() in excel and then have it
not change for next day if you open the excel sheet?  how would one do that?

I am trying to take a whole number and decimal and convert to minutes.  Production numbers are displayed on report as 1.41 where 1 is 60 minutes, and .41 is 41 minutes.  In this example I would need a calculation to translate the 1.41 to 101 minutes.  Any suggestions???

When I use Lotus 123, I can edit a number in a cell by
hitting F2 and then "+" and the number for a new number.
When I do this in Excel it interupts the addition of the
two numbers as a label. To get it to interupt it as a

I am assembling a work sheet and would like to change
which cell becomes active when you press ENTER. Not
necessarily down 1 or right 1, more to the cell of my
choosing.

I created a spreadsheet with a formula in A1 repeated
throughout A2 to A499. Cell A1 was CONCATENATE etc which
was fine and the whole sheet was protected.
When I unprotected the sheet and amended the formula, only

Can I activate a specified cell based on the TRUE/FALSE
result of a test question?  I want 'true' to make a
specific cell active, 'false' activates a different cell.
Cheers,