Recently, and I do not know how, all of the column headings in all of my worksheets changed to numbers (i.e. 1-4) as opposed to letters (as they are supposed...

I use excel often, but am only self taught, a work coluige embedded a excel file by accedent but we think thne use could for us usable, what is the pourpus...

Hi :D Please help! This is what I have got... I do 'For sale' ads. On each sheet is a different listing, for example, cars is on one, then the next is bikes,...

Excel 2002 I have a simple chart: two columns (A and B) and 29 rows. Column A is years, from 1980 to 2008. Column B is some value between 0 and...

I have a real problem finding the right formula to calculate fees based on a sliding scale of units sold. Here is the rule. Units sold in a month between 1...

I am trying to convert Dollar amounts into written text in an excel spreadsheet. How do I create a formula that will convert my Numbers to word text. i.e....

-- Rog

If I try to copy a paragraph from a web site and paste it to an excel worksheet it appear as a continuous one line sentence and not at the paragraph, even if...

How do I restore the number format for excel? For example: when I type in 45; cell automating displays .45. I have already tried going to...

I often enter manufacturer model#'s into my spreadsheet. If they begin with zero Excel automatically the zero. What can I do to change this?

Hi, I have 2 workbooks opened and the cell in the workbook that I am changing shows :- ='C:\TEST Roster Projections\6 WEEK ROSTER'!L10 However the value...

How do I "Unmerge" merged cells on the worksheet?

I have 6 columns each cell has a value either “Ok” or “Problem”. I would like to figure out how to automate on column 7 if I have three “Ok” in my row then...

Hi, It seems that the dozen workbooks I have created and the cross sharing of nformation with some single filesworkbook sharing several other files /...

Is it possible to have a cell i.e F14 - auto date with the days current date when you open the template? Andy JL

Hello, I recorded a macro and have a small detail I need to fix, but am unsure how to do it. At the end of the recording of the macro, I hit the right arrow...

Can u pls solve this Packs Quantity Total 500Kg 10 #VALUE! i need the total value as 5000Kg

I read the postings by other users, which sound like they work great, but I am in Excel 2007 and I can't FIND Edit, Paste Special...can anyone tell me how to...

I am converting a monthly revenue table to a quarterly revenue table. I would like to add A1:C1 and put it the result in a new cell and then autofill the...