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 / Worksheet Functions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
How do I create a macro to add zeros in front of a value?20 Sep 2006 01:54 GMT8
PLEASE SOMEONE HELP ME!!!
I have to add zeros to over 61,000 line items in excel.  I need to know how
to create a macro that will enable me to select a range within the same
column and have zeros added to the the numbers in the cell.
how do i change a case to proper text in excel 200320 Sep 2006 01:21 GMT1
Please help, I need someone to help me change case to proper cases on an
excel spreadsheet.
Result = to 0 says false20 Sep 2006 01:04 GMT5
I am pulling my hair out at this point and need some help.  
I have a worksheet with many cells and calculations.  
I have calculations performing on results of a calculation.  In then end of
all of this I have a If statement that says IF(Y4=0,"Yes","No")
Entering formulas20 Sep 2006 00:11 GMT1
I have a column that I want to reflect a 2% commission when I enter the sale
amount into the cell.  How do I accomplish this?
How do I conditional format by referencing failure/success?19 Sep 2006 23:41 GMT2
How do I conditional format a cell by referencing another workbook's
failure/success outcome?
Here's what I have:
Workbook #1 = a fax list with customer IDs and fax numbers
how do I edit an embedded spreadsheet?19 Sep 2006 23:14 GMT6
I recently received a "leads list", created in Excel, which consists of one
spreadsheet embedded into another. The embedded spreadsheet appears to be
very large (over 1000 printed pages) and contains a lot of irrelevant
information that I would like to edit out, however, I am ...
adding cells19 Sep 2006 23:10 GMT1
how do I add cells within a cell that is used as a function
multiplication19 Sep 2006 23:07 GMT2
Help all I am trying to do is multiply two cells together.
Cell one is 50.00 and cell two is 0.50 this should equal $25.00
All that keeps showing is the formula.
Help gives me this formula:  PRODUCT(E10:F10)
Cell Calculation19 Sep 2006 22:58 GMT5
I am setting up a input sheet for fees.
I have two cells side by side:  one where a dollar amount will be entered
and the other with a drop menu.  I need for the dollar amounts to be
calculated based on the drop down item chosen.  For example, if the dollar
How to merge monthly workbooks into a quarterly workbook??19 Sep 2006 22:56 GMT6
I do a monthly 3 sheet profit and loss sheet in excel for my employers
company and now he wants me to make a quarterly and yearly sheet combining 3
workbooks (or 12 for the yearly) into one. Is there any way to achieve this
by merging workbooks andif so how???? Please help!!!
Database Analysis Question19 Sep 2006 22:29 GMT3
I have the following
Column A B C D E F G
Row
1 Z Y X W V U
COUNTIF by days of week19 Sep 2006 22:25 GMT7
I have three columns of data as shown below, but  for the entire year:
      A                 B              C
08/01/06    Tue    2999.78
08/02/06    Wed    3283.59
Lookup and Replace19 Sep 2006 22:15 GMT3
I need some help in creating a look up to replace some data in my
spreadsheet. I had thought about using Access, but need to keep the cell's
in the format that they are in, and so cannot accurately import the data
into Access for manipulation.
How do I copy and paste a worksheet and maintain all formatting?19 Sep 2006 22:08 GMT2
I have formatted one worksheet to use weekly. Everytime I copy and paste it
for a new week, I lose some of the formatting. How can I maintain every
change that has been made so I can copy and begin data entry without
reformatting?
function to change cell position and allows dragging19 Sep 2006 22:07 GMT2
I want to enter a formula that will reference a particular cell, and then
allow me to drag the formula down so it references every third cell.  
So, if my data is:
    A
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.