|
Two numbers in one cell
I want to enter two numbers in one cell, separated by a space or dash. I then
want to use a formula to sum the left hand number in one cell and the sum of
the right hand numbers in another cell. I would prefer to use a cell formula
to accomplish the above. Thanks, in advance, Jed
...
|
3 |
29.09.2006 07:19:02 |
|
|
OR formula, translation to swedish please
Hi Does anybody kown what formula to use in swedish to translate "OR"
/Freddie...
|
6 |
29.09.2006 06:57:01 |
|
|
Paste Link
When i paste link i get zeros in all empty cells. Can i prevent this?
Anybody?...
|
4 |
29.09.2006 06:45:01 |
|
|
HOW DO I CHANGE A FORMULA INTO AN ABSOLUTE NUMBER?
how do I change a formula into an absollute number, so I can delete the
column where the number is.
I have a column in euros, a formula in another column to change it to
dollars.
I want the dollars column to be a number.
Thank you....
|
3 |
29.09.2006 05:56:01 |
|
|
Data Validation - Multiple Places Changing
I have some Data Validation I have used on a template worksheet that then
gets repeated over and over in a workbook. Different users then fill out the
worksheets. I want to change the input message that appears for the Data
Validation screen for all the workshhets at the same time rather than one at
a time. Group editing the worksheets does not allow me to do this. Is there
any way t...
|
2 |
29.09.2006 04:49:33 |
|
|
data analysis toolpak
I need to run a regression analysis using excel but the data analysis toolpak
isn't installed on my computer and I don't have the cd anymore. Is there
anyway I can download it from a site or get it somewhere?...
|
5 |
29.09.2006 02:17:54 |
|
|
How to connect characters together in different cells?
In cell A1 = ABC;
In cell B1 = 123;
I would like to join both strings together, then
In cell C1 = ABC123
Does anyone know how to do it in excel?
Thank anyone for suggestion
Eric...
|
3 |
29.09.2006 01:57:43 |
|
|
moving a worksheet..?
Good evening,
how do I take a worksheet from one wookbook and insert it in a diffeent
workbook, thx in advance...
|
3 |
29.09.2006 01:56:00 |
|
|
Forumla for averaging within a month
If you have a string of dates in column A and numbers in column B, and the
dates cover several years, is there a short cut way to write a formula and
have it sum or average the information in a particular month? Thanks
Example
1/1/01 3.11
1/2/01 3.55
…
...
|
12 |
29.09.2006 01:53:29 |
|
|
How do I have the date in a spreadsheet change automically.
I have created a spreadsheet in Excel 2003. This spreadsheet lists
contractors and whether or not they have public liability or workcover
insurance. The spreadsheet shows what date their insurance expires on. I
would like to know if it is possible for the cells to change colour
automically when the date changes. For example if the date expires on the
31/8/06 can I set up a formula to hav...
|
2 |
29.09.2006 01:37:02 |
|
|
Can't open excel files shown in my recent document?
I just started being unable to open excel files from "my recnet Documents"
list but they can be opened when a different user is logged on to the
machine. The excel files can be opened when I'm logged on by opening Excel
and going to file, open...
What caused this sudden problem and how can it be fixed?...
|
2 |
29.09.2006 01:36:40 |
|
|
Cell Format
Is there any way for me to paste what visibly shows in a cell to what the
data actually is? I have a cell that shows 1101 3/25. It is formatted as a
fraction. In the formula bar, the data shows 1101.12. What I really want is
for the data to be text and show 1101 3/25.
Thansk!...
|
5 |
29.09.2006 00:11:22 |
|
|
Can I automatically add or delete cells based on IF statements
Is it possible to set up a cell with a drop down menu selection of "Yes" and
"No" such that the selection of "yes" or "no" causes the spreadsheet to
display or hide additional cells with text. I am trying to set up a form
that contains questions that can be answered as yes or no. If the answer is
yes, I want to display a series of additional questions. Another way would
be to have an ...
|
4 |
29.09.2006 00:02:13 |
|
|
print preview is showing at 17" x 22"
Page setup shows that I'm setup for 8.5 x 11 paper. But when I go into print
preview, it's showing a 17 x 22 sheet. When I try to print, it either wants
the larger paper or it prints to size and creates a miniature version of the
spreadsheet.
Any ideas?
Thanks...
|
1 |
28.09.2006 23:48:01 |
|
|
cannot find excel add-in
We have an Excel-add that has been added via Tools|Add-ins and works.
However, when you go back to Tools|Add-ins you get the message
"Cannot find addin c:\xxxxx. Delete from list?"
If we answer No, add-in continues and we can verify that the XLA does exist.
If we exit Excel and re-start, Excel does not complain about the XLA being
missing, i.e. the registry OPENn is set correctly.
...
|
1 |
28.09.2006 23:26:02 |
|
|
Cannot copy cell
Hi,
Have a workbook with cells that are merged and wrapped. The text in the
cells often exceed 256 characters. I need to copy the information from one
workbook to another formatted exactly the same. When I select the cell and
copy then paste into the equivalent cell in the other workbook, I only get
part of the text (probably the first 256 characters). If I try to copy the
whole sh...
|
6 |
28.09.2006 23:22:02 |
|
|
How do I properly merge canadian zip codes?
Every time I perform a mail merge, the letters for those in Canada have a 0
for the zip code. How do I fix this so that their zip codes appear?
Thanks...
|
3 |
28.09.2006 23:20:02 |
|
|
How do I backup and recover customized toolbars.
I sometimes loose my customized toolbars and e-mail rules on my company's
network. How can I archive these setups so that I can recover them when lost?...
|
1 |
28.09.2006 23:04:02 |
|
|
Sort range by color
Hey everyone!
I need to sort a range of cells (A6:H600) by interior color. I've
found some code that will sort the entire page, but I need to sort just
the range. There are only cells with a color index of 6 (yellow) and
all the rest are white. So all I need to do is have the yellow cells
show up at the top of the range, and then I'll delete the rest. This
is what I found that works fo...
|
2 |
28.09.2006 22:57:31 |
|
|
How to: Change color of column / row headers and selected menus?
My colleague pointed out that in excel selected menus and row / column
headers for selected cells were highlighted orange on my screen and grey on
his. I subsequently noticed this to be the case for Word (but not Access).
Anyone know why this is? Is there a way to customize this setting?
Thank you, m...
|
8 |
28.09.2006 22:51:41 |
|
|
One more question, please
I have data set out in 4 columns. What I need to do is pick the value
in the fourth column (492 below) and look up the range in the other 2
columns that have the same value I picked in the fourth column. For
example:
Column 1 2 3 4
RB 2.46 0.0295 492
CP 4.62 0.0202 176
NG 11.28 ...
|
1 |
28.09.2006 22:43:06 |
|
|
Sort text that is deliminated within a cell
Hello all,
I am attempting to sort text within a cell. The text will mainly be
numbers, but the numbers may have some additional alpha characters in
front of it which do not affect the sorting order as only the numeric
values do. For instance, if I have the following
67432, 34321, 43456, imp41431, 644, imj1123
The sorted items should look like the following
644, imj1123, 343...
|
6 |
28.09.2006 22:19:43 |
|
|
Duplicating Worksheet to 20 sheet workbook
Ok...I have an Invoice that is on 1 sheet. How can I duplicate that sheet
into a 20 sheet book?
Then, is there a quick way to number sequentially. I want to assign the
first number, then the rest will automatically follow sequentially.
Thank you for helping!!
...
|
1 |
28.09.2006 22:17:02 |
|
|
my file opens but is missing from the screen
I have saved my excel file and have been able to open it until today. The
file opens but the screen is blank. In the toolbar, you can see and tab to
see what info is in the different cells, one at a time of course like normal
but there is no file to look at below the tool bar. I print the file and all
the information comes out on the paper. What can I do?...
|
3 |
28.09.2006 22:10:02 |
|
|
Text to columns
Hello everyone,
can I make this function work over a number of rows, where the text is
not the same in each row? or does it work on 1 column / 1 row at the
time?
Thanks
...
|
2 |
28.09.2006 22:04:31 |