Hi,
目前分類:title (5957)
- Jun 22 Fri 2007 20:38
run time error 1004 for other user
- Jun 22 Fri 2007 20:38
Dragging Formulas
What I am trying to do is add rows to an existing worksheet with multiple
formulas. The problem is after I add all of the rows and drag the formulas
- Jun 22 Fri 2007 20:38
Automatically add quot;0quot; to blank cells without a formula in the cel.
I use a spreadsheet that generates projected and actual hours/costs. The
projected hours/costs are generated by general support to a team multiplied
- Jun 22 Fri 2007 20:38
conditional formatting?
If I have a cell in say column F that has either the value of 1 or 0 and I
want the rows of the cells that equal 0 to turn green and the rows that equal
- Jun 22 Fri 2007 20:38
number formats
How can I combine decimal and fraction number formats. example 12.5/32
I've been using 64ths but it's not the proper format for my application.
- Jun 22 Fri 2007 20:38
if statement
I want to write a statement that says if option code = eefam, then 003, if
option code = eechd, then 002, etc.
- Jun 22 Fri 2007 20:38
Working with first and last names
I have the first and last names in one cell and would like to extract them
into a format that I can sort such as this quot;lastname, firstnamequot;. Is there a
- Jun 22 Fri 2007 20:38
send document from Excel to Word in readable form
How do I send a document from Word to Excel, and visa versa in a readable
format?
- Jun 22 Fri 2007 20:38
Convert Hyperlink to cell value automatically
I have a spreadsheet that lists company names with an attached hyperlink to
their website. I need to import the data from excel and would lke to import
- Jun 22 Fri 2007 20:38
Office 2000 Excel Macro runs very slow in 2003, why?
Hi
- Jun 22 Fri 2007 20:38
quot;Create a drop-down list from a range of cellsquot;
Dear
- Jun 22 Fri 2007 20:38
How to do I convert angles from radians to degrees in Excel?
I am trying to obtain the measure of an angle in degree format in EXCEL. I
found how to convert the angle using another funnction but that doesn't give
- Jun 22 Fri 2007 20:38
How can this be done
A B
1 Capital $176.00 lt;-January value in col b
- Jun 22 Fri 2007 20:38
display feet and inches
Is there any way in excel to display feet and inches? I can get decimal feet
and even fractional feet ie. 3 1/3. Is there any way to multiply the
- Jun 22 Fri 2007 20:38
How to make 1 cell add the 7 before it??
I am trying to make cell I add B, C, D, E, F, G, amp; H automatically... seems
easy enough but everything I try keeps giving me an error!!
- Jun 22 Fri 2007 20:38
most common number
I have created a sheet that reports incidents in my work place, I need
to be able to report if a particular number ( employee indentified by
- Jun 22 Fri 2007 20:38
List of items appeared in range
Hi,
I have a list of codes:
- Jun 22 Fri 2007 20:38
printing columns
On my excel sheet i have columns and rows, when it come to printing they
don't show up on the paper how do i get them to show ?
- Jun 22 Fri 2007 20:38
Split text without using data-text to columns
I have the following in cells
D3: -2.5 -111