|
|
changing the pagebreak by
marilyn
I am unable to change the pagebreak on any spreadsheets
and the fit to one page is not set. Is there another
setting that could be preventing me from changing...
|
|
1 |
85 |
|
|
Changing values by
Becca
We are in the process of changing our accounting
software. I have two columns, one with the old account
number and one with the new, corresponding number. ...
|
February 10th, 2004 09:58 PM
by Becca
|
2 |
268 |
|
|
Auto input? by
Crystal
From: Crystal
Subject: Auto input in different columns
Date: Tuesday, February 10, 2004 4:07 PM
I have a workbook that I input customer...
|
February 10th, 2004 10:10 PM
by Crystal
|
0 |
247 |
|
|
conditional formatting by
Jon Barchenger[MS]
Good morning Jamie -
Sounds like you want to change the Number Format of a cell based on a value in a cell, using Conditional Formatting.
Sorry you only can...
|
February 10th, 2004 10:38 PM
by angela
|
3 |
262 |
|
|
Calculate cooking time by
Pierre
This one's got me:
Trying to calculate "begin cooking" time based on length of a foods
cooking time until done, and desired done time.
IOW. . .
Need a...
|
February 10th, 2004 10:43 PM
by Pierre
|
3 |
486 |
|
|
Ye olde blank cell question.. maybe by
XLguy
I assume this question has been asked a dozen times but *I* haven't
quite seen it asked yet. I have seen similar questions but they are not
the same.. at...
|
February 10th, 2004 10:49 PM
by XLguy
|
3 |
476 |
|
|
Daily To Weekly Formulations Down Columns by
Vanguard
I have a spreadsheet that has daily values in one column
with data in the second. On another tab, I have weekly
rollup data to give me a sum or average of a...
|
|
1 |
166 |
|
|
Excluding a cell from the print area by
Tim Richards
I need to exclude a cell from printing on my report. This cell happens to be in the center of my worksheet. I want the cell to be displayed on-screen, but not...
|
|
2 |
169 |
|
|
Amortizing Term on a loan by
Rachel
How do I figure the amortizing term on a loan?
=ABS(NPER(+K8*0.01/12,-(J8),,-O8))
This is currently the formula that is showing. This is a spreadsheet that...
|
|
1 |
79 |
|
|
A way to not refresh data on screen? by
Kenji
When I run the macro, the Excel sheet does a bunch of activities.
Is there a way to disable refreshing the screen.. so the user doesn't have
to see all the...
|
February 11th, 2004 02:45 AM
by Kenji
|
3 |
115 |
|
|
|
|
2 |
131 |
|
|
|
|
1 |
402 |
|
|
|
|
2 |
327 |
|
|
Auto size row by
mgolden
I can't seem to merge cells and wrap text and have the row
automatically size itself to fit the data.
If you wrap text in a single cell it works, does...
|
|
2 |
235 |
|
|
Removing blank characters in a cell by
Roger Govier
Hi Goonly
Try
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(12),""),CHAR(160),"")*1
to remove both spaces and / or the non-breaking space CHAR(160) which
sometimes occurs...
( 1 2)
|
|
14 |
577 |
|
|
Extract Text Outside of Brackets by
Frank Kabel
Hi
if you have only one textpart within brackets for each cell you may try
=LEFT(A1,FIND("",A1)+1,1024)
to get everything except the bracket text...
|
|
2 |
413 |
|
|
|
|
0 |
120 |
|
|
|
|
0 |
393 |
|
|
Minutes and Seconds by
Lynn
I exported a spreadsheet that contains mm:ss (1:10), but
when I pull it up in Excel it shows 70. Like it added
the minutes and seconds. How can I convert...
|
February 11th, 2004 01:11 PM
by Lynn
|
2 |
83 |
|
|
Sources and Uses by
BldrBldr
Hope you can help. Looking to solve for value "X" which
makes the sum of "Sources" equal to the sum of "Uses",
that is, how much do I need to break even. It's...
|
February 11th, 2004 04:22 PM
by BldrBldr
|
2 |
235 |