|
|
Excel changing date format after VB has run by
Richhall[_2_]
Hi
I have a sheet 1 with a combo box and a blank field. When something
is selected from the combo box a date gets populated in the blank
field. The date is...
|
|
3 |
102 |
|
|
validation controls in excel by
harini 04B01A0503
Can I get a formula fr applyin a validation control on a cell which
accepts alphanumeric values with specified text length..its abit
urgent fr me..im new to...
|
|
1 |
128 |
|
|
Sending data to tabs by
Kirk
Hi,
Im trying to send data to different tabs. I have sorted the data in column C
so the numbers run one after the other. Is there a quick way of sending the...
|
|
2 |
147 |
|
|
IF & VLOOKUP by
Surya Vyas[_2_]
Hi,
I need to look up data structure number (for eg: 4) and match the same with
structure range from 1 to 6. and if the data structure matches, and it has a...
|
|
0 |
92 |
|
|
|
January 5th, 2010 01:33 PM
by Max
|
14 |
233 |
|
|
CHANGE TEXT DATE TO NUMERIC DATE by
slf
The following imported data isn't recognized as a dates:
Jul 4 2008 6:30AM
Jun 22 2007 5:59PM
I have tried both of these formulas found elsewhere in the...
|
|
5 |
140 |
|
|
looking for a function that hopefully exist by
formula_hardrocker
i want to lookup a value in a column on a worksheet and if that value is true
i want to take that information in that row and insert it into another...
|
January 5th, 2010 10:04 AM
by Max
|
1 |
113 |
|
|
blank cell instead of x by
bill gras
I need a formula to have a blank cell instead of a "x" eg:
result
should be:
aa ab...
|
|
2 |
128 |
|
|
|
|
0 |
104 |
|
|
|
|
0 |
80 |
|
|
Multiple Values by
JJ
My next problem is I need to extract only certain information from a
worksheet as sample-
Worksheet A Worksheet...
|
January 5th, 2010 08:52 AM
by JJ
|
5 |
137 |
|
|
|
|
2 |
86 |
|
|
|
|
2 |
102 |
|
|
Pivot table for worksheet text fields? by
Tom Mitrano
Can a pivot table concatenate text that appears in a worksheet?
I often use Excel to lay out questionnaire responses. Pivot tables are
great to calculate...
|
|
2 |
125 |
|
|
|
|
4 |
109 |
|
|
non-numeric in a calculation by
Albert.Harmse[_2_]
I need to calculate hours worked for the employees. The staff reg got the
moths dates in row 1, and "time in" and "time out" in row 2. Column A is for
all...
|
|
1 |
107 |
|
|
cell formattiing by
Kamron
I have to export a spreadsheet from another data base. The numbers come over
as ##-####-##-#, and I am unable to change their format. Does anyone know
how...
|
|
2 |
124 |
|
|
|
|
6 |
97 |
|
|
Paste Special/Format by
Kamron
Whenever I try to paste cell A's format into cell B, the value & format of A
gets pasted into B. The same result happens when I use the paint brush...
|
January 5th, 2010 02:36 AM
by clr
|
1 |
95 |
|
|
#NAME? Error With User Defined Functions by
Thomas M.
Excel 2007
I have a problem that has been driving me nuts. I created a code module and
have pasted a couple of user defined functions into the module. When...
|
|
7 |
176 |