Whenever I populate a numeric value into a cell, the leading zeros are always
removed even when I create a custom format. Excel thinks its a number but I
want to treate it as a character because I have to FTP the file to a
mainframe. I always get the warning that it contains some ...

I have a spreadsheet that displays a cell's contents in column E based on a
numberical identifier in column B. These cells targeted by the VLOOKUP cell
are located in a seperate part of the same worksheet. I would like to
transfer the comment of the target cell along with the ...

Excel 2003. I have a worksheet using conditional formatting to put shading in
cells based on what's selected in another cell.
The cells with conditional formatting are unloacked to allow data entry. If
data is copy and pasted from another cell it overwrites the conditional

I would like to be able to use superscripts and subscripts and also to allow
the text in a cell to wrap, but it is ponderous to go into the Format Cells
box, but I can't find how to put a button for those functions onto my toolbar
for ready access like many other functions.  Does ...

(I posted this in the office.misc newsgroup by mistake)
I've used the following to try and have VB select a sheet dependant on the
value in d2.
Dim ss As Variant

Hello -
I have the below data set.
Product    Period    Item
A    Q1    1

I want to display the following information in one spreadsheet.
Product, OS supported, Browser supported.
There are multiple products, OS’s and Browsers supported.
Could some suggest a good template for this?

I have a form (wk sheet) for each day and I need to keep a running balance.  
I currently enter the formula manually each day to reference the previous day
and carry balance forward.  April 19 (4.19) I would enter ='4.18'!H38 to
reference the previous days total (April 18).  Is ...

I have figured the nper for a loan on a number of amortization schedules on
the net.  However, when I use the npr function in Excel, I get a different
number of periods.  Why would this be?  For example, in excel for a 2.9/12 %
loan, 16,472 pv , 0 fv and a $505 per month payment, ...

I need to get the formula to figure the years and months of return on an
investment
cost of investment  (g16)= 100000
Yearly income (k31) = 33480

I have 3 columns containing month (entered as january, february,etc), day of
month, year(2007,2008,etc).  I would like to create a column with the date in
regular date format (2/1/07).
Do I have to use some form of VLOOKUP together with the DATE function?

I need help, if possible to design a function:
If Column "AUFNR" is empty, I need to replace the Value in column "Pool2" by
the value in column "AUFNR" for the same pool.                                            
Then I need to multiply the value of column "Owner" for the value in column

I have this formula that works in Excel 2007. I need to get it to work in
Excel 2003. Can anyone help?
SUM(COUNTIFS('Sheet1'!B6:B100,"incident",'Sheet1'!T6:T100,B4)+COUNTIFS('Sheet2'!B6:B100,"incident",'Sheet2'!T6:T100,B4))
Alex.W

If I refer A1 in B1 and then copy B1 to B2. In this case B2 will be reading
A2 which is obvious. As i further copy B2 to lower rows it will continue the
same way. Where the column is same but the rows are progessive. My question
is that is thr any way I can copy cells down the ...

I have a column of numbers and text that I am trying to use in a vlookup
formula.  Rather than go thru the numbers and add a ' at the front to format
as text, is there a simple fix that I can employ to change these 500 or so
numbers.....