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 / April 2008

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
VB problem17 Apr 2008 18:27 GMT5
I'm looking for a code that would do the following:
- When I press whichever data entry validation key combination(((("Enter",
"Ctrl+Enter", "Shift+Enter", "Tab" or "Shift+Tab")))) following data entry
into a cell from either B or C columns, then if...
Changing File Title Fonts17 Apr 2008 18:15 GMT3
Is there a way to change the Font or color on the title of a file or Folder?
can I change font color for a date which is appoaching to act as17 Apr 2008 17:28 GMT1
I am using Excel and have added a date to a cell.  I want to set up some form
of alert on an impending date and wondered whether I could arrange for the
date to change font colour "x" number of days before the date.
Regards
reinstall excel????17 Apr 2008 17:16 GMT4
i accidentally uninstalled I think all my microsoft office 2003
applications(i can't access word or excel or open any files i receive from an
email) is there a way to reinstall it, the program was on our computer when
we bought it so we don't have a CD to reintsall it
counting17 Apr 2008 17:12 GMT2
I'd like to know if you can count words inside of a cell that are separated
by a comma.  For example, if i have N,S inside of a cell, I'd want a count of
2.  If i had NA,S - i would still want a count of 2.  NA,S,C - i would want a
count of 3.  Please let me know if this is ...
nested conditional query17 Apr 2008 17:04 GMT3
i have some work that i'm trying to sort and then subtotal like info.
Column A  Column B  Column C
 acct #      $$           subtotal
what happens is that i get a check with 100 accounts, some duplicates
checkbox17 Apr 2008 16:43 GMT1
I need to change the size of the physical checkbox itself.  I found in
propertis how to change from font size, background color etc...   Any ideas?
VBA question about selecting worksheets17 Apr 2008 16:39 GMT3
I am writting some code and i am stuck on how to select a worksheet.
There is a month listed in cell A1 of Sheet1.  It is a validated cell
to select months.  The rest of the Sheets are labeled named with
months ie. January, February ...    Based on what is in cell A1 on
Filter to Duplicate Entries Only17 Apr 2008 16:38 GMT2
How can I setup a filter to show me only entries that appear more than once
in a collumn?
How do I allow a multiple selection from a dropdown?17 Apr 2008 16:34 GMT11
How do I allow a multiple selection from a dropdown?
I know how to create a list / dropdown with multiple options but now the
question is - how can I choose more than one option?? I know that usually it
works by pressing CTR, scrolling down the list and choosing mulitple options. ...
Hiding rows17 Apr 2008 16:27 GMT2
Wondering if there is a way to hide a row depending on the value of a
certain cell.
eg. if any cells in column C has "xxx" then hide entire row.
I'm guessing there is a way to do it using logic or conditional formats but
"minimize multiple excel workbooks on windows taskbar"17 Apr 2008 16:22 GMT4
I recently installed Internet Explorer 7 on my computer.  Before installing
it, I was able to have multiple workbooks open and when minimized they
appeared on the windows taskbar.  Now they are minimized in one workbook.  
Any ideas on how to minimize them again on the windows ...
business hours formula help17 Apr 2008 16:08 GMT3
I have used this formula:
=(NETWORKDAYS(D14,E14-1)*8+(MOD(E14,1)-MOD(D14,1))) to calc the time between
start and stop considering an 8 hr business day.
the problem is that i am getting a negative if the start and stop is in the
How to avoide data conversion when opening a text file?17 Apr 2008 15:57 GMT18
I have a text file, in the first column I have dates in the format MM/DD/YYYY.
When I open this file in Excel the first column looks bad:
8/31/2006 stays the way it is.
12/01/2006 is converted to 12-01-06 which is wrong - somehow Excel thinks
Rounding up or down17 Apr 2008 15:51 GMT4
I am working on an excel spread sheet running price costing numbers.  I want
the numbers to round up to multiplies ending in 5 or 0.  Example if I have a
cost of $ 122.18, I need to round to 120.00 if the the number is 124.88 I
need the number to round up 125.00.
 
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.