start time 11:00:00 PM (A3) end time 3:00:00 AM (B3) i am trying to use mod to work out the number of hours that a person worked using excel so i used the...

I have one worksheet in a workbook Protected, and I save the file that way. When I open the file again, the worksheet is no longer protected, although if I...

Here's a macro that works fine for me. It converts a formula in the cell where the cursor is to a value, or formulas in selected cells to values: Sub...

Firstly I'm a total newb to excel (and access for that matter LOL) I have almost 25,000 rows of data and I'm a little scared LOL its a basic set up, Total,...

I've done all the searches online and off for help. Now time's running out for my project. Here's the situation... My data is in two columns with thousands...

I've inputed data across about 60 worksheets, and now I want to combine certain areas from each worksheet into a different worksheet. Is there anyway to do...

i have eight sheets in a worbook---they have headers, footers, row heights, column widths, font sizes, etc. can I format these so that everything ...

Test Post

test

I will try to express myself clearly but I might not be able to fully do so: I have a 22 page worksheet with each page as a technical data sheet. When i print...

I used Macro function in Excel WorkSheet.But now the Stop Recording/Relative Reference Button ToolBar for Macro does not appear any more?Can someone help me...

i have three questions: 1. sometimes a sheet or an area outside the sheet becomes grayish in color. what does this mean and how does it hamper my work? 2. what...

Hi!, I have an auto update import on a access table, it works mostly ok, it update all user entered fields ok, but the fields that come up automatically when...

I have a model in Excel 2003 with macros that I have converted to Excel 2007 *.xlsm. I have set the security to "enable all macros." However, when I load...

I have managed to get the info accross no problem but the formatting is all over the place. For instance - 07/10 meaning July 2010 is appearing as...

I need date format to be set up as month/year ie 05/10 for may 2010. I have tried everything and cant seem to figure this one out?

Hi guys, is there a way to convert the following 123456789 to 123-456-789 or abcdefghi to abc-def-ghi I need to convert a long list of serial numbers so I can...

I want Excel to resize cells, based on the content I put in them, automatically.

I am plotting a chart in Excel 2003 using non-sequential data points as shown below. Time Value 0 0.07 2 0.09 4 0.14 6...

I have a question I was hoping someone could help me answer. I have the function =IF(I22M20-1,-M20,IF(J22M21-1,M21,N22)) in cell M22. Now I would like to...