|
|
/P Startup Switch in Excel 2000 by
Joe
I'm trying to use the startup switches in Excel 2000 to do
the following:
Open a spreadsheet as read only, and set the "save" path
to a different...
|
|
1 |
457 |
|
|
Locked for Editing problem -- Solved by
dh
There have been many posts in this forum regarding problems with Excel reporting "Locked for Editing" when, in fact, the file is not in use by anyone else....
|
July 22nd, 2004 05:05 PM
by dh
|
0 |
208 |
|
|
Date Calculations by
simoncohen
Cell A1 contains accounting Period start Date say 1/2/04
A2 contains accounting period end date say 31/1/5.
A3 contains a different start date say 1/4/04 and...
|
July 22nd, 2004 03:45 PM
by acedia
|
3 |
297 |
|
|
Extracting Email Addresses by
Jumbo
Hello all,
I need some help on how to extract email addresses from a worksheet that
contain cells with either text or an email address. The problem is...
|
|
3 |
226 |
|
|
MS Query - Parameter Bug by
TedGrier
I have an Excel 2002 worksheet connected to a SQL Server 2000 database.
The data query is simply:
SELECT Count(*) FROM Orders WHERE SALE_DATE=
When prompted...
|
|
2 |
220 |
|
|
Comparing Text in adjacent columns by
ADArnold
Good Morning Group,
I am a Commercial Real Estate Broker and I have several databases with
building tenant and owner information that I need to make mailing...
|
|
6 |
377 |
|
|
Creating a pivot table for text data by
Kelly
Is there any way to create a pivot table for data containing alpha characters? I need to create a cross reference table for a 3 column list of data with...
|
July 22nd, 2004 02:41 PM
by Kelly
|
2 |
368 |
|
|
|
July 22nd, 2004 02:39 PM
by Posty
|
4 |
716 |
|
|
|
|
2 |
150 |
|
|
mph in excel by
rawclark
Does anyone know of a formula for calculating time from
speed and distance?
As in d=3 miles; s=45mph; t=00:04 (hh:mm). There must be
a standard formula for s....
( 1 2)
|
|
14 |
248 |
|
|
merge or combine columns by
Lee Beck
Is there a way to combine columns? I have a spreadsheet
with a couple thousand rows. I want to give each row a
unique identifier that has the components of a...
|
July 22nd, 2004 01:44 PM
by
|
5 |
339 |
|
|
|
|
1 |
156 |
|
|
Excel Opens 2 files, I only created one? by
Andy Wiggins
You get these by clicking on: Window New Window
To get rid of excess windows, click on "Close Window" (that's the cross in
the top-right of the screen...
|
|
1 |
401 |
|
|
scrub file before submitting by
goss
Hi ng
Using xl 2003
Need to scrub a text file before submitting
Desired output:
Inv # || Inv Amnt || Date || FAS? || FAS#
Problem:
|
July 22nd, 2004 06:38 AM
by Biff
|
4 |
196 |
|
|
Excel Worksheet Formula Question by
TCIDawn
I know there is a simple formula for this, but I haven't had to work
with this for so long, I just can't seem to pull it from my memory, and
I don't know the...
|
|
3 |
399 |
|
|
copy data validations from 2000 to 2003 by
A0
Hello,
Is there any known problem with copying cells with data validation (list)
from excel 2000 workbook to excel 2003 workbook ?
Copy / Paste - paste the...
|
July 22nd, 2004 05:34 AM
by A0
|
6 |
221 |
|
|
fractional pennies by
gary
28,000 cells are SUPPOSED to be rounded to 2 decimal
places. However, their total is:
28,0004,231,983.34000001000.
How do I find the cells containing these...
|
|
7 |
151 |
|
|
|
|
1 |
135 |
|
|
after hitting enter by
Don
When you hit the ENTER button.. the cursor will move either right,left,up or down... Is there a way to have it move to specific cell for example if your add...
|
July 22nd, 2004 03:06 AM
by Ragdyer
|
2 |
196 |
|
|
|
|
3 |
344 |