How do I create a formula to convert inches to show feet and inches (examples, 118.75 = 9' 10 3/4" , 85.875 = 7' 1 7/8")?

Hi, I have tried going to Page Setup on an Excel 2003 sheet and changing envelope to 8 1/2X11 sheets. I cannot make it default to 8 1/2 X 11. Every time I...

Is there a method/function to auto hide rows dependent on the value of a cell in that row ... Ie cell B3 = 0 ...... hide row ??! Many thanks again Alan

Hello I'm trying to write a formula for the following: If the value in cell B8 621 AND if the value in cell B21 3000 value = YES

This statement returns the correct result for records meeting these conditions and dated before...

Hi, How can I extract the day from the date, ie date is "31/12/04" - need "31" returned in an adjacent cell. I need to have "31" returned as a numeric tho...

Here's the scenario: A B C 1 10 0 2 20 1 3 30 2 4 40 3 I want to...

I can't get a sum on a Currency formatted field in the table. I can get an Item count. Suggestions are most welcome. wal50

Hi I have two columns with date + time like this Startdate Enddate 11/08/2004 19:00 11/08/2004 22:17 11/08/2004 19:30 11/08/2004...

I am an experienced excel user, but stuck in the same basic functions. I am trying to move my skills to the next level, and am currently building a model which...

I have a tool where a beginning date is entered and then I need toi calulate number of weeks between my beginning date and whatever date we are at for the next...

I could tranform an excel page via special paste (transform) special paste now seems to have changed there is no transform can I do this a different way

In Excell, I would like to be able to copy from a list simply by clicking on cell and dragging the info to a new cell without losing the info from the original...

I found the =BAHTTEXT() formula to convert to Thai, but can't find anything to convert in English. For example, I am trying to convert "123" into...

Forum, How do I change the Macro so when I run the macro again to update values I added to my source sheet I will get the correct update. Everyday I add to...

Howdy. I'm trying to figure out the best way that I can have Excel automatically insert a new worksheet when I enter data on another sheet -- be it a...

I want to calculate a period of time in 24 hours to be able to work out the running speed of a machine. This is ok using say 18:00 to 21:00 the resulting time...

Here is one for you... I want to make a workbook with the following ability. Pick an item from that drop down list in column "A" and it shows a price in...

A column in spreadsheet.... If I want to auto filter I go to Data/Filter /Autofilter....This is fine except that having done that the arrow for auto filter...

I have created a function "vlook up" which worked fine, however I would like to add the function "if" to avoid have some cells N/A instead of a number...