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
Decimal Points and comma separators23 Jan 2008 02:47 GMT2
I work with very exact numbers, sometimes up to 7 significant figures after
the decimal point, and I copy/paste this numbers from another program. My
problem is that my comma separator appears as a decimal point and my decimal
point is a comma, and sometimes the people i hand out ...
Toolbars23 Jan 2008 02:43 GMT1
I set up excel so it will not display the reviewing tool bar but it keeps
coming back.  How do I make this stop?  It is not a big thing but is
something the drives me nuts.
Thanks!!!
add decimal to beginning of number23 Jan 2008 02:41 GMT1
i am importing fixed width text file but cannot get leading zeros to come
over and can't add decimal to left side of number when in excel.
i.e.
text file data = 0004
Los Angeles Movers23 Jan 2008 02:41 GMT1
Moving Guide World Moving & Storage Whether this is your first or
fifth move, moving to a new home or even a new town can be an exciting
experience. However, relocating also has the potential to be quite
stressful. By planning ahead and considering all the specifics
Copying Formulas23 Jan 2008 02:40 GMT1
I'm trying to copy a formula from 1 spreadsheet to another.  The formula
always changes to show the filename of the previous spreadsheet.
How do I copy/paste a formula "as is" without the filename being attached?
Formatting23 Jan 2008 02:38 GMT4
In Excel 2007 is it possible to format a minus number with brackets.
Ex: (2013.70)
Exlude Zero Values from Average23 Jan 2008 02:37 GMT2
I have a pivot table which contains target values.  I want to get an average
of the targets excluding the zeros.  I've included simplified data below.
Fleet       Subfleet       location      Target
PG          PG1              42090            3
personal23 Jan 2008 02:36 GMT1
Is there a way to remove a personal.xls?  Everytime I oen excel and work on a
workbook there is a personal.xls showing in the background.  How do you
remove this?
Countif23 Jan 2008 02:34 GMT2
I need to countif 2 diff criteria's are met in diffrent columns for ex:
       A              B
1.    FCC           18/01/2008
2.    FID            18/01/2008
SUMIF Question23 Jan 2008 02:32 GMT2
I have the following formula:
=SUMIF(Data!$T$6:Data!$T$20000,"Long
Term",(Data!BE$6:Data!BE$20000/sum(Data!BE$6:Data!BE$20000)))
I am having a problem in making this work.  I want it to look in cells
Saving just 1 worksheet out of a workbook to a separate file23 Jan 2008 02:31 GMT1
I'm not sure the chat room is working...but, I have a workbook with several
worksheets.  I want to save just 1 of the worksheets by itself.  How can I do
this without saving the entire workbook?  Hope this is getting through.  I
show no posts since the 21st.  Thanks,
xlsx file conversion23 Jan 2008 02:30 GMT1
A co-worker was sent an excel file with the extension xlsx.  Is there
something she can download to convert it to an older version of excel?  
Thanks!
splitting data23 Jan 2008 02:28 GMT1
    Sam Smith       
    5/9/2007       
    Sam Smith        I need to have the names in one column and
    Mary Jones        the dates in another
Tabs in excel23 Jan 2008 02:19 GMT7
I don't know if this is possiable but if so it would be great.  I have tabs
will call them
Method 1
Method 2
minimum formual help23 Jan 2008 02:15 GMT3
Simple but can not get this. I have just 12 cells need to pick out the
minimum excluding 0. Tried =min(if(b1:b13<>0)) and entered as an arrary.comes
back as error with 0 highlighted. Any help would be appreciated
Thanks Scott
 
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.