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

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Find/Replace changes cell format ??????23 Jan 2008 10:08 GMT2
I have a column in spreadsheet containing codes - they are 4-digit
numbers
some of them contain leading zeros. So column is formatted as Text to
preserve
worksheet_save macro help23 Jan 2008 09:49 GMT5
My worksheet contains worksheet_change event based on range name "ID".  What
i want is when i save or close the workbook i want ID = "". I have written
the following code
Private Sub Worksheet_save()
Double variable value in excel23 Jan 2008 08:52 GMT1
I had a question about how the double variable is used in excel.
When I program in C++ and I assign x = 2; where x is a double the actual
value is
1.999999999 or 2.000000011 but in excel it is exactly the number you assign
Formula Help23 Jan 2008 08:49 GMT1
I need some help with a formula.........
When an amount is equal to or greater than negative 2.50 i need the outcome
to say 0.  When the amount falls into one of the other categories i need the
outcome to correspond to the correct dollar amount below.
Making selected cells more visible23 Jan 2008 08:46 GMT3
In Excel 2007, among the many new things I'm trying to get used to is the
faint highlighting of selected cells.  If I select a cell, or a range of
cells, Excel highlights the selection as it always has.  But the contrast
between those highlighted cells and the unselected cells is ...
Data23 Jan 2008 08:41 GMT1
When I program in C++ a variabl declared as a double
x = 2.0
comes out as 2.0000001 or 1.99999999
but in excel it is 2.0 exactly why is that?
loan amortization schedule23 Jan 2008 06:28 GMT6
Hi, I have the loan amortization schedule loaded & am using it to amortise
equipment (so it may be the wrong template to use???). I need to enter in a
balloon payment for the final payment but it's not calculating how I want it
to, can anyone give some advice on setting up a ...
Possible to change/update values in range of cells by X% ?23 Jan 2008 05:54 GMT2
Is it possible to update or change the values in a range of cells by a
certain percentage? What I'm trying to do is apply a 10% increase to a column
of prices (several hundred cells long) without doing it manually one by one
or creating a new column (B) that references the values ...
This should be easy - Part 223 Jan 2008 05:53 GMT1
Sorry, I wasn't able to post a reply to my earlier theread, so I had to start
a new topic...
Here is my spreadsheet:
            ---Date Range---       
This should be easy... part 223 Jan 2008 05:53 GMT1
Sorry, but this site would not let me post a reply to my earlier thread, so I
had to start a new one...
Here is my spreadsheet:
            ---Date Range---       
formula to pull names out of list23 Jan 2008 05:30 GMT3
If I have a column of names (BUT the names are repeated) in a listed and I
want to have a formula that pulls out each name 1 time and puts it in a list
on a different sheet how do I do this.
Example WorkSheet 1
Worksheet Tab Names23 Jan 2008 04:50 GMT1
I have a workbook with 16 sheets.  I want the Sheet Names (Tab Names) to
reflect data on Sheet 1 in various cells. Example Sheet 2 name will reference
Sheet 1 Cell B3,  Sheet 3 name will reference Sheet 1 Cell C3, Sheet 4 name
will reference Sheet 1 Cell D3. Sheet 5 name will ...
Pivot Tables23 Jan 2008 04:07 GMT1
I have a source sheet that has several columns in it (see below).  The column
for RC can have a number in it from 0-23.  When I create a pivot table with
this data (see below), it throws RC in whatever order it wants.  I would like
the legend to read in numeric order.  Any help ...
VB code for running a macro23 Jan 2008 02:53 GMT3
I'm trying to write a couple lines of code for a macro, call it Macro1.  I
want Macro1 to be able to run Macro2.  What's the code command for that?
Thanks,
rcc
Password Protect Macro - Compile Error23 Jan 2008 02:50 GMT1
Please help me to discover what is wrong with this excerpt from a macro that
I am writing to protect a sheet in my workbook with a password. I keep
getting the compile error message.
    __________________________________________________
 
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.