|
|
How do I truncate linked text? by
Jenni
I am linking text from other worksheets, but I only want a portion of the
text to appear in the final document, using a certain number of characters.
Any...
|
|
1 |
98 |
|
|
Counting text within an Entire Workbook by
Carrie_Loos via OfficeKB.com
Hi -
Need help, still stuck. I have a workbook with several worksheets. Each
worksheet has an inventory list with a part number and perhaps a word
"missing"...
|
|
5 |
135 |
|
|
open workbook to specific sheet by
Mr E
I am trying to force excel to open to the same workesheet each time the work
book is opened. regardless of where it was last saved. Is this possible? If
so,...
|
|
1 |
89 |
|
|
IF Formula by
SilviaG
I have formula =min(312,200+8) and im trying to add the IF function to it as
well, with the logic that if 0312 that the text will change a certain color
if...
|
|
1 |
74 |
|
|
Excel by
Bear
Without manually changing each entry how do I change a column of positive
numbers to negative numbers.
Thanks in advance
Bear
|
|
2 |
74 |
|
|
Format custom number: C-0000-L by
Sonia
Hi, I need to format a few cells in Excel to look like C-0000-L where "0000"
represents four numbers and "L" represents a letter.
I tried to do it in format...
|
April 9th, 2010 05:56 PM
by tompl
|
3 |
96 |
|
|
Excel is reading formula as a value by
Louise[_5_]
how do i get excel to read ='sf-14'!ag13 as a formula. i want the value from
one worksheet to appear on another worksheet.
--
Louise
|
|
3 |
89 |
|
|
Conditional Formatting Confusion... by
frakincaprica
What I am trying to do seems simple to me.
I have a forumla in A2. A2 = B3-B2
I want to know when A2 is not equal to a value in F2. (Red)
I want to know when...
|
|
2 |
92 |
|
|
|
April 9th, 2010 04:46 PM
by Xman
|
0 |
86 |
|
|
|
|
3 |
83 |
|
|
|
April 9th, 2010 04:40 PM
by Geerdad
|
0 |
113 |
|
|
Protecting sheets with drop down boxes by
Dolores Gomez[_2_]
I have a spread sheet that has drop down boxes with functions and
validations. I want to be able to protect this spreadsheet so that users can
only be able...
|
|
0 |
93 |
|
|
Include CDF to workbook by
JP Ronse
Hi All,
I want to use COUNTDIFF (Morefunc add-in) and sometime ago I have read
overhere that is was possible to attach a function to a workbook (Excel
2007)...
|
|
2 |
64 |
|
|
Help to resove this problem. by
MAX
I have a workbook with 3 sheets.
Sheet 1 is named (D), Sheet 2 (Settings) and Sheet 3 (Countries).
In sheet (D), I have all the countries that I require ( 39...
|
|
1 |
63 |
|
|
|
|
4 |
72 |
|
|
COUNT BLANK AND ZERO AS THE SAME THING by
jjlang
I'm writing an IF function and want my formula to return a 1 if the cell has
a number in it, but return a 0 if the cell is blank of has a zero in it.
ie Cell...
|
|
6 |
110 |
|
|
Help with N/A in formulas by
Mark D
Afternoon everyone
I have 2 formulas that I need a little bit of help on. Both are working fine
but I want the cell to be blank if the result is N/A. Just...
|
|
3 |
96 |
|
|
|
|
1 |
100 |
|
|
Hyperlink to the meat of a cell by
Pierre
This would be easier for all of us if I knew the right terminology but here
goes nothing. I have an excel spreadsheet with approx 5000 part numbers. I am...
|
|
4 |
166 |
|
|
Hostname from IP address by
NickT[_2_]
Hi,
I am hoping someone can help me please..
I have a spreadsheet that is linked to a survey being hosted on our website.
The survey is about internet safety...
|
|
1 |
160 |