Does MS Excel have any tool wherby a number can be converted to words, Eg., 12345 be converted to Twelve Thousand Three Hundred and Forty Five etc.?

The first two columns in my spreadsheet are dates. The third is text. When I try to concantenate, the dates turn into numbers. Any advice would be greatly...

Hello.... I was wondering just how much Excel 2003 can take with regards to massive amounts of Functions/Formula? I have a workbook and two worksheets have...

Hi, What formula is needed in G3, H3 & I3 to create the combined totals of row 2 & 3? Columns B, D & F identify the numbers in A, C & E. Finished spreadsheet...

I have a long list of times in formatt 10:23:45 (HH:MM:SS). How do I add X number of minutes to these times? Ex: 10:23:45 add 4 minutes Thanks for the...

Can anyone help me correctly write an IF function for multiple cells? Here is an example of what I am needing help with: A2, B2, C2, D2 are all yes or no...

I have this great model to calculate project returns, really flexible in lots of ways. I have an amortization table for project loans and I can change the...

I have a worksheet like: 162-1 162-2 162-3 163-1 163-2 .......... I 'd like to average the group of cells with the same first three digit? I am thinking about...

Hi folks Here is a cut down version of a lookup im using to find the best choice for a customer, as you can see from the row that starts 30 the customer...

Copied bank html statement to Excel Worksheet. Columns of numbers &/or cell will not accept a format change to Currency. Same columns would not add. Did...

I am using the following formulas which work fine. =SUMIF(B2:B145,"AER*",I2:I145) =COUNTIF(B2:B145,"AER*") I would like to use similar formula to sum values...

Hi, Supposing I have the following data in A1:D4, Tag Jan Feb Mar x 1 4 3 x 2 1 6 y 4 5 9

i have a single column of data. how do i highlight the duplicates in the list. i've tried conditional formatting and can't get the formula right. some...

OK Thanks to the help of members of this board I learned to use SUMIF to sum the values of a column based on a condition... but what if I have multiple...

I have this formula that is working great, but I need to expand on it and I have no idea how: =IF(H123="","",IF(H123="Not...

I am a novice macro writer and need help with the following. Here is a piece of a macro I...

I clicked my mouse and color banding started on a file. I don't know how to turn it off and it would be very useful to use on other spreadsheets if I could...

Hello all, I have a someone sharing excel 2007 spreadsheets with others using excel 2003. She is saving it in the 2003 format and everyone has the neccesary...

-- Be Lucky.

I am doing a SUM of values in a column starting at row 6, so I use a formula like this: =SUM(I6:I9999) I can't do I:I because there are irrelevant numbers...