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 / New Users / October 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
adding problem with formulas28 Oct 2006 04:29 GMT5
This may be just me spending too much time today in Excel, but I'm
having a problem with what I think is a simple problem.
I have multiple tabs in a spreadsheet, with tabs reading off of other
tabs.
comment has name & is bold28 Oct 2006 03:12 GMT3
Whenever I insert a comment it has a default format of boldface and my first
name typed in.  I don't want either.  I want just a blank, normal format
comment box.  How can I get that?
Thanks for any help,
Macro runs when I click macro in tools dropdown27 Oct 2006 21:25 GMT1
Somehow I've assigned a macro that runs when I try to access all the
macros from the dropdown box Tools, Macro, macros.
How do I get rid of this so it goes back to its proper function?
HELP!!
Excel conversion to PDF?27 Oct 2006 21:17 GMT2
I have a huge text (several hundred pages) of Turkish in Excel format. Since
some special characters are being dropped or altered when printing the Excel
file, I need to convert the file into PDF to get a proper printout.
Unfortunately, I am only able to convert on a page per page ...
price list rounding27 Oct 2006 21:15 GMT1
I am able to adjust the whole range of prices by paste special multiply.  
Cant figure how to make the range round to the nearest whole dollar amount.
DATE IN TEXT FORM - NEED TO CHANGE IT DATE FORM27 Oct 2006 20:34 GMT3
When I download data into excel some of the dates in the data comes as:
     2Sep'06
I edit the cell by taking out the apostrophe and the value becomes a date. What formula / function can I use to take out or clean this apostrophe and make it a date?
Thanks
RoundUP formula27 Oct 2006 19:37 GMT2
Just need round up results of formula =0.15*E2
is this correct?
=ROUNDUP(0.15*E2),2)
thanks
Simple graph27 Oct 2006 19:29 GMT2
I have a chart with zip codes and a population rate.
ZIP        RATE
80001     2.34
80002     1.23
set toolbox optionbuttons27 Oct 2006 18:50 GMT1
I want to set some (control toolbox-) Optionbuttons in a worksheet to
"True".
I retrieve the names of which Optionbuttons I want to set from another
sheet, and put those names into an array of Strings.
SUM PRODUCT & CUMMULATIVE BALANCE27 Oct 2006 18:14 GMT3
I am able to use SUMPRODUCT to sum amounts based on dates as shown below:
=SUMPRODUCT((sheet2!$C$2:$C$1000=C1)*(sheet2!$E$2:$E$1000))
Column C have the dates and Column E have the amounts
How can I do cummulative balance using the SUMPRODUCT?
Extract Value from another worksheet27 Oct 2006 18:06 GMT6
I have a work sheet that has parameters Mem1, Mem2 etc. I have another
Worksheet ehich has the values for these parameters e.g.  Mem_rom_234g
for Mem 1 and so on.
I am looking for an excel macro that can take the value of mem from
Small 1-2 on worksheet's left in Excel27 Oct 2006 17:56 GMT2
I have a spreadsheet with several simple worksheets.
In one of the worksheets, at the very left, there has appeared a small "1
2".  Under that is a vertical line and a series of dots, one dot per row. At
the end is a minus sign.
Excel 2003 Crashing after a few hours27 Oct 2006 16:59 GMT3
As subject states, one of my users works in about 10 different spreadsheets
all day long (5 of them are shared workbooks) and roughly every 3 hours excel
says there has been a problem and will close and recover the spreadsheets.
Sometimes it won't even give the warning message ...
Multiple Excel Windows27 Oct 2006 16:31 GMT2
I have two screens. I'd like one spreadsheet on one screen, another on the
other. Is this possible?
To me, Excel does not behave like other programs, where different files can
reside in its own, seperate window, like Word. Why, then, when I open
Simple - does Col B exist in Col A?27 Oct 2006 15:14 GMT5
Simple question.
I have a whole bunch of Names in Col A, like 500.
I have 10 names in Col B.
I want Col C to look at each entry in Col B and see if it exist anywhere in
 
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.