Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / December 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Time difference21 Dec 2007 21:55 GMT13
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 GMT2
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 merge21 Dec 2007 21:33 GMT1
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 GMT5
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 shortcuts21 Dec 2007 21:23 GMT6
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 GMT1
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 Mode21 Dec 2007 20:11 GMT6
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 GMT6
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 Date21 Dec 2007 20:09 GMT4
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 GMT1
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 Box21 Dec 2007 19:53 GMT1
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 worksheets21 Dec 2007 19:52 GMT3
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 GMT1
I've looked for .xlb's and followed the other postings. However, my Excel
alpha menu bar is just gone.
Wrong Data Prints21 Dec 2007 19:50 GMT9
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 error21 Dec 2007 19:41 GMT3
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))
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.