A long time ago I had some code to add a drop down menu to Excel. Can some kind soul please direct me to a location where I can recapture that code.\Thanks

Here is what I want to do: If a cell (formatted as number) is between 0 and 10 multiply it by this. If it's between 10 and 20 multiply it by that. How do...

I am trying to create a 24-hour staffing schedule but I cannot figure out how to automate the process. There are 7 overlapping 12-hour shifts with two work...

i am very very new to excel and i have created a report that has some formulas in it..everything looks good. so i print it. when i reopen the report a box...

Not sure if I worded that correctly. Here's what I need to do: I have sales data for a month that is listed individually by date and item number. I need to...

How do I check if the content in a cell, when divided by 4, returns an integer? It should give me 150 if it is an integer and display "NA" if it is not an...

Dear All, I need an automatic formula or a format that give's me the ability to enter these numbers (Handling Time) as (HH:MM) but to be converted to...

I'm a total newbie to Excel (and without a manual), and my boss has asked me to generate commission reports based on an Excel worksheet. Can any one tell me...

Try this =IF(MOD(A2,4)=0,"Integer","No an integer") Mike "prem" wrote: How do I check if the content in a cell, when divided by 4, returns an integer?...

Hi, I'm a a co-worker sending me spreadsheets that are created in alother program and saved as Excel files. I have no problem opening these in MS Excel 2003...

I recorded a macro to input a number, move right 3 spaces, enter a number, ect ....... when I recorded it I intended to go back and replace the numbers I put...

When I change the default font in a new Excel Worksheet I seem to have to change it inn each cel individually. How can I do this more efficiently.

I'm very new to Excel and have taken a long time to work out some formulas in a workbook. This book is shared by people who have little or no knowledge at...

A newly installed version of Excel 2007 does not show any recent documents after restart even when I have used the pushpins. Any one have any ideas please?...

I made a database of press and radio contacts for my record label. In one column i list contacts websites. Only some of the url's pasted in are highlighted...

Hi, Is there a formula to calculate failure rates in excel? I have a life expectancy, age of equipment, and failures in a year and would like to have a...

One of the MVP providing very good help here has just what I am looking for... I am looking for the code to place in a mergedfield to show dollars & cents as...

Hello, I have a user form that named Splash_Form and I want to make it so it cant be moved around the screen. I want it to stay in one spot in the center....

I hope this is possible to have happen all in 1 formula How can i compose a formula that would acheive the following: If the number in J5 is at least...

Hello How can I convert 3.5 hours to 3:30:00? -- Emma