General

Spell out date
Is there a formula or VBA code to make "July 8, 2008" automatically say "8th day of July, 2008"? Any help is appreciated. ... 8 Jul 2008 14:08

if formula
Need help with this formula. If AH12 minus AL7 is greater than 0 but less than 30, then AH12 minus AL7 times AE7, if AH12 minus AL7 is greater than 30, then return value in AE7, if AH12 minus AL7 is less than 0, return blank. (AH12 and AL7 are dates) AE7 is a monthly rate. ... 8 Jul 2008 12:05

COPYING FORMULA CONTAINING NAMES/RELATIVE RANGE NAMES
I am an old quattro user who has emigrated to Excel 2007, and being frustrated by Excel Range names. My apologies if this has been asked before, but I couldnt find. -Basically, I have two columns of figures(Say "Month Sales" & "Year To Date Sales" -I need to set up a report based on these figures with various... 8 Jul 2008 11:03

ctrl + down
I have columns A,B,C,D,E all with 66 rows of data(in other samples i have more or less than the 66 rows, this is just given for my example). In column F, i have my formula that I want to carry down to row 66. But when I wite my code "selection.end(xlDown).select" it is selecting the entire column and when i... 8 Jul 2008 12:04

Sort by date but not year
A coworker maintains a list of clients' birthdays so we can send a card. She wants to sort it by the date column so that we have all of July's birthdays in one section, for instance. However, when she types in the month and day, it automatically assigns the current year to the date, even though it is not disp... 8 Jul 2008 11:03

Rounded corners on Tables
Management seems to go LALA for nice curved corners on their tables when you present reports, and I was wondering if this was possible using Excel 2007. The office is due an upgrade at some point in the far distant future, and believe it or not, curves on the corner of our cells is a huge selling point. I can'... 8 Jul 2008 11:03

ATTENDANCE SPREADSHEET
Me again! Some of our students have to attend 6 times and some 7. They are listed down column A with various details (including attendance) running across the row. At the end of all of their attendance days is a 'total attendance'column. Assuming they all attend all of the days (I wish!!) is there a one formula... 8 Jul 2008 12:04

tell me the formula of converting amount to million from koror
... 8 Jul 2008 12:04

Switch to change data fields to 0's, then back to original data?
I would like to set a switch that will switch data in certain fields to zero, then will refill with the originally entered data when the switch is turned off. I think that I have seen this before in an excel program, but I cannot figure out how to do it. Anyone know how? ... 8 Jul 2008 10:01

data not updating
Hi, I have a problem with my formulas not updating to the correct value. for example i have 1 in col A and 2 in col B, and col C = A*B=2. The problem is that say I change col B to 5, Col C will still remain at 2. It will also still remain at 2 if i drop down the formula again. The only way that it will upda... 8 Jul 2008 10:01