|
|
Date not recognized in Excell 2000 by
Myrna Larson
Try using the formula =DATEVALUE(MID(A1,58,20). Convert formulas to values via
Paste Special if needed.
On 28 Jul 2004 13:41:39 -0700,...
|
|
2 |
184 |
|
|
|
|
2 |
703 |
|
|
Validate a Range of Cells by
CTInt04
Hi,
I want to stop a user from being able to put a number twice in a column of cells. For exemple I don't want column A from row 5 to 60 to contain the same...
|
|
2 |
206 |
|
|
ODBC add in by
Manolo
I am using office 2003 and I can't find the ODBC add in.
How can I add the ODBC add in in excel? In ecel 2002 I
have not problem going to Tools-Add ins...
Any...
|
|
3 |
173 |
|
|
Hide colum by
rodw
I want to hide colums based on a cells value
so say if a1 = yes i want to hide colums b to f
and if a1 is no then i want to hide g to j
Is thi possible
---
|
July 29th, 2004 11:51 AM
by rodw
|
2 |
307 |
|
|
Macro to extend a pivot table range by
Debra Dalgleish
You can use a dynamic range as the source for the pivot table. There are
instructions he
http://www.contextures.com/xlPivot01.html
Phil Platt wrote:
...
|
July 29th, 2004 11:56 AM
by Vaughan
|
1 |
562 |
|
|
#N/A by
Rob Lloyd
Hi,
I'm using a VLOOKUP formula that looks for a value in one sheet and, if it finds it, putting the value in another sheet. This works fine and as I am...
|
|
1 |
143 |
|
|
Stuck spreadsheet by
Kathy
I have a spreadsheet that is shared and someone has
dragged up so high you can't get a hold of it to drag it
back down to make it all visionable. Any ideas on...
( 1 2)
|
|
11 |
264 |
|
|
Sorting by multiple names in excel by
JulieD
Hi Scotty
Easiest option is to use the Data / Text to Columns feature to separate the
names
(delimited & space as the character)
Select the column with the...
|
July 29th, 2004 02:35 PM
by
|
1 |
682 |
|
|
|
July 29th, 2004 03:03 PM
by clane
|
2 |
311 |
|
|
|
|
2 |
330 |
|
|
what is the best way to do this? by
mck
I have data that I have exported from Access. The data is
over time and is a 27 question survey. There are also
over 30 departments. The questions have...
|
July 29th, 2004 03:18 PM
by mck
|
2 |
146 |
|
|
Macro Error: Unable to get Var property by
Peter Bernadyne
My macro appears to have trouble calculating variance (using the
worksheet function) for a range of cells I have.
The code I have is:
Lead_Y =...
|
|
2 |
282 |
|
|
CommonDialog Problem by
Nny
Every time I use the commondialog control, it seems to
remember the last path and filename is opened. I need to
clear this information and have it use a...
|
|
1 |
158 |
|
|
Gridlines / No Gridlines by
BillCPA
I have downloaded a spreadsheet that has none of the automatic gridlines in the area where the data is. I have gone to the Options tab and made sure the...
|
July 29th, 2004 04:04 PM
by BillCPA
|
5 |
305 |
|
|
|
|
2 |
441 |
|
|
ODBC Select Data Source by
bunzl
Hi,
I have users who generate ODBC queries in Excel 2000 using system
dsn's.
I have system dsn's set up which are pointing to the same databases as
the users....
|
July 29th, 2004 05:13 PM
by bunzl
|
2 |
523 |
|
|
|
July 29th, 2004 05:15 PM
by dremel
|
0 |
432 |
|
|
xml schema update by
Carl
Is there any way to avoid remap everything when you only make small change to your xml schema? anybody has experience on this? thanks.
Carl
|
July 29th, 2004 05:52 PM
by hgrove
|
1 |
248 |
|
|
|
July 29th, 2004 05:56 PM
by hgrove
|
1 |
153 |