|
|
Set Cell format using VB.NET by
Hugh
Hi,
I want to open a exsiting CSV file and set the Data Format of column A (Date
and time) to Date (m/d/yyyy) and column width to certain number. I can open...
( 1 2)
|
March 4th, 2010 11:06 AM
by babu p
|
10 |
1,346 |
|
|
|
|
23 |
1,343 |
|
|
Paste Link Grayed Out by
Steve M
I have successfully used paste link several times before.
I now have a destination worksheet into which I was able
to paste link one value successfully. Since...
|
October 16th, 2003 09:20 PM
by Felipe
|
4 |
1,335 |
|
|
date conversion by
web_time
Is there an easy way to build a two-column table with gregorian dates in one column and Hebrew dates in the other? And then for each year, have it...
( 1 2)
|
|
10 |
1,322 |
|
|
remove 'click to add data' page? by
mfouche
after I saved a excel document to pdf format the header and footer appeared,
with a page on the right and bottom saying 'click to add data' How do I
remove...
|
September 18th, 2009 08:45 AM
by mfouche
|
0 |
1,321 |
|
|
|
|
7 |
1,296 |
|
|
GET.CELL by
Biff
Hi Folks!
Anyone know where I can find info on the argument values
for GET.CELL?
I saw a post a couple of wks ago that had a link for a
help file from MS but...
|
November 24th, 2004 07:16 PM
by Biff
|
2 |
1,293 |
|
|
How to remove a suffix in excel by
BC
type I have the following example data in cells and need to separate the
suffix.
Adelphi Blue7
The suffix may be alpha or numerical but in all cases there is...
|
February 13th, 2006 10:41 AM
by BC
|
3 |
1,288 |
|
|
|
June 6th, 2010 11:16 AM
by Mike
|
1 |
1,281 |
|
|
|
|
3 |
1,281 |
|
|
If/Then Formulas by
Bk Goto
Hello and Good Day =)
I am in need of some help...
I would like to create a formula where
IF cell F7 =1 then E7*1, IF F7=2 then E7*1, IF F7=3, then E7*2
Any...
( 1 2 3 ... Last Page)
|
|
38 |
1,280 |
|
|
VLOOKUP WITH ALPHA NUMERIC by
JACOB
i HAVE ALOOK UP RANGE THAT HAS IN THE 1ST COLUMN NUMBERS & OR NUMBERS &
LETTERS THE vLOOK UP ONLY GIVES ME THE NUMBERS IT GIVE n?A ON THE ALPHA OR
ALPHA...
( 1 2)
|
June 16th, 2005 04:10 PM
by VG
|
14 |
1,276 |
|
|
Combo Box & Linked Workbooks by
D B
I have two questions:
1. Drop Down Boxes: Is there a way to actually convert a
cell(s) to be a combo box? The only way I have been able
to achieve this is...
|
|
1 |
1,271 |
|
|
|
|
1 |
1,271 |
|
|
Calculating pay dates by
BW
If a date is a friday, I want to display the previous Thursday (MM/DD/YYYY).
If a date is a Saturday - Thursday, I want to display the Thursday as a date...
|
June 6th, 2010 04:58 AM
by BW
|
4 |
1,269 |
|
|
|
|
10 |
1,252 |
|
|
Excel "IF" function problem by
Johan
Our domain uses group policy to configure user rights on
the workstations, and it appears that on certain machines,
or rather under certain user profiles, the...
|
September 15th, 2003 03:08 PM
by JM
|
2 |
1,246 |
|
|
Determine "on time" status by
Teri
I'm trying to write a formula to determine if a delivery is on time. In the
example below, I used =IF(O6=N6,"Yes","No") and Excel returned "No", but
this...
|
June 3rd, 2010 11:18 PM
by Teri
|
9 |
1,243 |
|
|
Weibull function in Excel by
Barbo
I have a survival dataset (see below). I want to fit to Weibull function
S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
gamma=2.32. If...
|
|
3 |
1,242 |
|
|
fax multiple worksheets by
volleyman
does anyone know how to fax multiple worksheets in the same fax job? I am
using MS Windows 2003 Fax Services and Office 2003 running on Windows XP.
when I...
|
|
0 |
1,240 |