Functions

Help converting a 10 digit number 2223334444 to 222-333-4444
In MS Excel (2007) I have a very long column with 10 digit numbers that need to be changed to a telephone number with dashes. Can anyone help? ... 28 Dec 2009 12:58

excel formula
I have rows of inventory numbers and I need to add a single number to the number already in the cell, make sence? I am adding additional inventory to the number in the cell and I don't want to have to add the numbers. ... 28 Dec 2009 02:05

excel 2003 allowed addition of cell color anywhere on the page?
self explanatory, cell color was moveable from location to location on the page. Excel 2010, can't find option??? ... 27 Dec 2009 21:47

Init Caps
I used the Proper Function in a Column to pull records that were proper titles/names of software from a list, however it did not catch what is known sometime as 'HumpBack Caps' e.g. QuickBooks or ACT! Is there a function that will find these as well? ... 27 Dec 2009 17:25

Can I Rotate with a Condition -or- Can I Display Graphics with a Formula
I am trying to write a function that will display less than and greater than signs, but do so in two directions; I'd like them to go left to right or up and down. So my questions is, since I can't find a char() for a reverse caret, is it possible to either rotate the caret with a conditional, or is there a way to ... 27 Dec 2009 11:56

S- Curve Calculation and chart
Dear All, I have to prepare S-curve for the Project with following informarion Project Duration : 30 Months Project Cost : 90,000,000 Note : I tried Total Cost / Duration = Monthly work done amount I need calculation based on S- Curve Please do the need ful at the earliest. Wish you all a very happy New ye... 29 Dec 2009 04:17

N/A Error with VLOOKUP Formula - Excel 2007
I have used the following formula to replace N/A with 0, where there is no value to return. =IF(ISNA(VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE), 0 ,VLOOKUP(D18,'KOTC_Customer Price List '!A:E,2,FALSE)) However, the formula does not register and the above formula just shows as text in the respective cell... 3 Jan 2010 00:51

Calculating Elapsed Time Over a Set Period
I have created a table which shows the amount of volunteer hours I have worked each day. I then created another column which I wish to create a running total of the hours worked each day. e.g: A B C 1 Date Hours Running Total 2 01/09/09 03:30 03:30 3 02/09/09 0... 26 Dec 2009 13:18

Alternate row comparison
I've seen a few similar problems, but not quite what I'm seeking help for here. My goal is to write a formula to compare 2 rows of summed values for a lengthy spreadsheet - comparing the values of even-row scores and odd-row scores -- (Col G) here. So 5 is > 3 for rows 1&2; 4 is > 3 for rows 3&4, etc. Here's an... 27 Dec 2009 06:34

Literal based on Week end
I tried these to NO avail: Cell D51 contains a formula -> =TEXT(B51,"dddd") For Cell E51 I want to enter an IF condition based upon the Weekday value in Cell D51. So, here is what I have tried and I also have tried some other variations: 1. IF(D51="Sunday" OR D51= "Saturday","No Hours Recorded","Charged") ... 26 Dec 2009 12:12