| Thread | Last Post | Replies |
|
| Time difference | 21 Dec 2007 21:55 GMT | 13 |
Is is possible to find out the difference between two dates in Hours. eg 4/4/2007 0.00AM and 5/4/2007 0.00AM Difference is 24 hrs Please sort this out...thanks in advance for the help.
|
| Data Validation from a list - Always case specific? | 21 Dec 2007 21:35 GMT | 2 |
Hi I have created a data validation list. If user types value instead of selecteing from drop down does user always have to enter case specific. Eg list is "Y" and "N". user cannot type "n"
|
| Mail merge | 21 Dec 2007 21:33 GMT | 1 |
I know how to use mail merge with Word by getting data from Access... Can I use mail merge with Excel and use the data from Access.....? TIA
|
| Can I use Dynamic Ranges to automate complex calculations? | 21 Dec 2007 21:25 GMT | 5 |
I have read lots of threads on how to create Dynamic Ranges. I also know I can use it to automatically update a chart or do some simple calculations. But I am still struggling to do the following: Suppose I have Column A as a dynamic range called "Date", Column B called
|
| can not open any excel file from my desktop shortcuts | 21 Dec 2007 21:23 GMT | 6 |
I now can not open any excel file from my desktop shortcuts. This occurred after I updated to the latest Microsoft update. I get the following; .xls is not a valid Win32 application." This just occurred after updated to XP service pack 2.
|
| start:1 and start:2 - how did i get 2 copies? | 21 Dec 2007 21:14 GMT | 1 |
I am working in a spreadsheet called start. For some reason I have start:1 and start:2 When I close one of them they both close When I go to where start is saved it just says start.xls - i click to open
|
| Excel 2007 always opens in Compatibility Mode | 21 Dec 2007 20:11 GMT | 6 |
I have a user who recently upgraded to Office 2007. Every time he opens Excel 2007 (not a spreadsheet, just the application itself) it opens as "Book1 Compatibility Mode". How can I fix this? I know when you open pre-07 spreadsheets they open that way, and I know how
|
| How to pull the rightmost, non-zero cell value in a workbook? | 21 Dec 2007 20:10 GMT | 6 |
See subject above. In column A, I have a long list of properties. Columns B through W are dates, and the data listed below shows various percentages. Not all of the cells are populated, as I leave them blank until I receive the data.
|
| Need help converting Number stored as Text to Date | 21 Dec 2007 20:09 GMT | 4 |
Ok, I tried using the kb article for this, but obviously I'm still doing something wrong.... please help if you can! I have a number 121101 in a cell -- when I right click the cell and select format cells it says it's formatted as a date, but the error checking says
|
| rdwj--You out there? | 21 Dec 2007 20:00 GMT | 1 |
rdwj: Yesterday, you were helping me to get a calendar control set up in Excel. I think you intended to send a link but it wasn't there. Could you please send it along...I'm really wanting to be able to add the small icon so I can click
|
| Search Box | 21 Dec 2007 19:53 GMT | 1 |
I am making a small dictionary in Excel 2003 and will like to know if someone knows how I can insert a search box to find a word of the dictionary. Thnaks a lot!!
|
| Cell referencing between differnt worksheets | 21 Dec 2007 19:52 GMT | 3 |
There are 2 worksheets. Say I want cell A2 in sheet2 ALWAYS to equal cell A2 in sheet1. The data in sheet1 is cut and pasted quite a lot due to the way we work and when this happens the link is corrupted. I think I could use INDIRECT but there are quite a lot of links and if I ...
|
| My menu bar is gone. How can I restore it? | 21 Dec 2007 19:52 GMT | 1 |
I've looked for .xlb's and followed the other postings. However, my Excel alpha menu bar is just gone.
|
| Wrong Data Prints | 21 Dec 2007 19:50 GMT | 9 |
I'm trying to help my boss w/this. The spreadsheet she sees on her screen prints different data. It doesnt say any of the formulas are incorrect. It will say 1,709 on her screen and print something like 1,300 after the
|
| zero error | 21 Dec 2007 19:41 GMT | 3 |
Good morning I'm trying to do an IF formula to resolve the #DIV/0! error that i get in fields that are still waiting on data. this is my formula: =IF(SUM(C20/I20)=0,0,(C20/I20))
|