I am new to excel and trying to convert a spreadsheet i got which came with fractions, I would like to convert them to decimals.

A have a single column list with each row in the list containing one of 750 possible text values. The list runs 11,000 rows so there is substantial...

How to avoid circular reference in a following formula: A1=if(b10,2*b1,a1)

Hi everybody I made a set of internally & externally linked excell workbook, and I would like to prevent copying and distribution What is the best way to do...

Hi there, I am working in Excel worksheet that represents an invoice. When the total price is calculated I need to translate the invoice sum into a...

Hi All I have set up a sheet to deal with some orders. I have used one row per order, and created columns for up to five items, with Item Code, Qty and Total...

Hello All I am trying to write a function so that if A or N appear in a row, the number of occurances will be counted and logged. If the result = 0 then that...

I have set up a custom form in excel for users to select or type data into that then sends the information to a new sheet in a list format at button click...

I do not know how to hide a worksheet in excel, so that even the tab does not show. Can anyone help me out...

Is it possible th put a check box in a cell? I have added check box'es to a work sheet but I can not get them to be in a cell say A1 it allways over laps onto...

I have a list of addresses in the following order: names (a1), business names (a2), streets (a3), city state and zip codes (a4), business phone (a5), cell...

Back in 2003, Mick Massey wrote "Does anyone know how to change the colour of the little arrow in the auto filter box when you have sorted a list?" and David...

plz. i need a help. How can I use countaif with many conditions or any similar formula?

Hello, A1 A,B,X,C,X A2 X,D,G,X A3 F,G,K,L,X I need to count how many X repeated at many cells using sumproduct function.

I am using Excel 2003. Sometimes we use conditional formatting and make some rows invisible which are not matching the criteria by setting their colour white....

This occured to my friend's worksheet; I don't have exact details of what she was doing at the moment; but she was entering simple address data to an address...

I am using a spreadsheet with different formulas that I use for business purposes which is updated each month. Each month I create a new tab as JAN07, FEB07,...

If I have a formula I use a lot, is there somewhere to enter or save it so that I can pull it up when creating a new worksheet I might like to use it in?...

How can you calculate the rate of return for a series of payments not necessarily equal?

When I enter comments in excel worksheet cells,and later try to view the same , the comments do not appear adjacent to the cell where entered. They appear at...