why does a cell return a decimal when text is linked in an "if statement"???? ... the format of the cell is set to fractional. This statement...

View Toolbars then look dwn the list for Control Toolbox John "Sol" wrote: I want to create a spreadsheet with a list box and a command button. Where...

I have an extensive price list with my buy prices. I need to add a plus 7% margin to the final purchase figure. Could someone give me an answer please.

I need to create an excel spreadsheet but not sure how to achieve it. (this is for commission payout) On sheet 1 starting lefthand side is "name" next column...

My Macro does not DELETE the ROWS from the specified Worksheet whene SAVESTR is NOT Found. If SAVESTR is found it deletes the other ROWS. However I need to...

I can do a search of entire computer for info in Excel worksheets with older versions of Excel. In 2007 I can only search withing on sheet at a time.

I am trying to "Refresh the Data" for my Pivot Table. My data is a lot longer then it used to be. How do I make sure that all numbers are included in the...

Hi, I am not able to combine all sheet's contents in a single sheet. Please provide me any macro to run this type of issue. And, Is there any need that any...

I'm new to using Excel, but I was wondering if anyone knows if it is possible to create (or "automate" might be a better word) the following type of work...

I am having all kinds of strange things happen in my computer. It is probably caused by the loose nut on the keyboard. Anyway, my task bar no longer has the...

Need a template for use with this program.Anyone help?

I have a spreadsheet with several simple worksheets. In one of the worksheets, at the very left, there has appeared a small "1 2". Under that is a vertical...

People, I have an eMac running OS 10.2.8 with Office 2004 for Mac installed. I applied all the latest updates for Office. I am trying to create a header for...

I have copied this formula to an other workbook, but I keep getting #NUMBER as a message? I have copied the original several times bu cannot get it...

how to minimze cell in access

And I guees the code would help g Sub SetColour() With Selection .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="=" &...

I am trying to fill in scores from a golf match in an excel spread. When I try to enter individual scores I get the # sign for some of the numbers. This...

hi i was wondering how to make a drop down box so i can select a name for say my taxinvoices for my clients instead of having to type in the whole thing ...

;) I'm keeping track of daily sales at a small store. I would like to open one spreadsheet, enter all the sales for the day, and have a running 'year to date'...

:confused: I don know how to explain but imagine Course (eg Math) arcoss the top students ( John, Kim...) down the side each course is different in lenght(...