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 / May 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Excel displaying values incorrectly11 May 2005 13:14 GMT3
I am trying to open this xml file with excel but it isnt displaying the
number correctly:
<?xml version="1.0" ?>
<ps>
delete single space11 May 2005 12:57 GMT1
please help
how can i delete the space in a text box
e.g.
cloumn a  
how to control the size of a comment  shape11 May 2005 12:54 GMT1
i wonder how to control the size of a comment  i added in a cell with vba.
i failed all,
thanks
This is a doozy...11 May 2005 12:52 GMT1
I don't even know where to begin with this one.  I have information that
needs to go into some form of a chart--any chart.  I need to show the number
of departments in several buildings that are compliant with rules from Jan
thru April.  Basically, from what I can see, I need to ...
Want the cell blank11 May 2005 11:50 GMT7
Using Excel 2000.  I have a formula below.  If the cells D41 and E41 are
blank, it returns this #DIV/0!  I would like the cell to be blank if there
is no info in it.  How do I do that?
=D41/E41
trim11 May 2005 11:10 GMT4
I am struggling with Trim.  Please can somebody advise me step by step what I
should do to remove an unwanted space from text entries.  I have a column
which is approx 2000 rows long, and quite a few of the cells have a space
before the text (ie on the left hand side of the text) ...
Data Validation11 May 2005 10:51 GMT2
Hope some genius out there can help.
I need to ensure that users enter a numeric value in the current cell of a
range of cells. I've attempted to use the "Data Validation" feature of Excel
but do not want to restrict the user to a particular range of numbers, but
Need to change text to csv11 May 2005 10:09 GMT3
My credit card company has an export feature.  One of the options is ".csv
(Excel).  This used to give me a nice clean spreadsheet with each column of
information in a separate Excell column.  I guess it converted on the fly or
something.  But now it seems to be a "comma ...
Comparing two lists10 May 2005 23:54 GMT5
I have two lists in a workbook, each on there own sheet.  I want to find if
the value of on cell in list "A" has an exact match in list "B".  Also how
can I strip all characters preceding the character "/" in a cell and also
remove the space that is right after the character "/"?
excel formatting10 May 2005 23:20 GMT3
i have a spreadsheet that lists by salesman po's and their value.  how do i
create a formula so that i can add all the rows just for a particular
salesman.  i do have the drop down list on the salesman header.
How do you do 'if' statements?10 May 2005 23:02 GMT5
On sheet 1, column B, Line 27, I have to enter 'M' or 'F'.
On sheet 1, column B, Line 28, I enter an age.  '54'.
I need on sheet 1, column C, to populate the health rate based on the
criteria entered, 'M/F' and 'age'.
creating macro10 May 2005 21:30 GMT2
I know very little about VB in Excel but I've gone through the "Record New
Macro" to copy several different fields in different rows to a single row
and several columns.
The problem I have is the macro always runs against the same data in the
pie charting through excel, using power point10 May 2005 21:00 GMT2
Hello~
 I am working on a presentation for class.  We used a yes and no survey, I
think I figured out how to pie chart.  But, now I want to insert that into
power point.  How do I do that.  I go through INSERT, PICTURE, then I click
non numeric pie charting10 May 2005 20:30 GMT1
Hello~  
 I have conducted a survey of five questions being yes or no questions. I
need to figure out how to put my results into a pie chart.  I saw on an
earlier thread where you need to do a pivot table.  This is my first time
Problem with Protection and Hyperlinks10 May 2005 19:58 GMT2
I am having a problem with protecting a worksheet that has hyperlinks
in it.  I have set the cell protection so that only the three or four
cells with hyperlinks can be selected.  When I turn on protection on
this sheet and someone tries to select a protected cell it acts like
 
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.