I have a spread sheet with company, name and tel columns. I need to convert
the Company column to all caps. ???

Hi, can anyone tell me how to change the value of an empty cell to a zero
please?
I am using =SUM(A1-B1 A2-B2 A3-B3 and so on)
It performs the sum ok and everything, but when one of the cells is blank,

The following code is working for everyone but me:
=IF(MOD((i_LoadHeavy*2),3)>0,
TEXT((i_LoadHeavy*2)/3,"###.#"),(i_LoadHeavy*2)/3)
This code is part of a worksheet used by many and developed by some guy on

Hello and thanks in advance -
I have a column of room numbers with [alphas] mixed in as seen below.
A          
100

I want to reference a sheet name within the spread sheet itself as text.  I
know I can do it in a header/footer using the &[tab] function, but I'm
creating a tool that will be seldom printed.  Is this possible?

Hi, I need to run a formula on cells which themselves contain formula. The
second formula is subtracting, say, A1 from B1. The problem is when there are
no answers in the dependant cells (A1, B1 or both) – it, as expected just
gives a value of #VALUE!

I have a spreadsheet that is about 8,500 KB that is painfully slow to
calculate. While I can certainly set it manual calculation, my preference is
to leave the calculation set to automatic.  In doing a little testing on the
file I discovered that the culpret seems to be multiple ...

I have been having trouble trying to work out a formula for the following.
One cup of flour weighs 160g.
If I had 240g of flour I would have 1 1/2 Cups.
Now the hard bit, there are 16 Tablespoons and 48 teaspoons in a cup of

I have a text value in cells A1:D1.  Let's say that the values read across
the row:
A1 = "Duck", B1 = "Duck", C1 = "Cat", D1 = "Duck"
I want a formula in cell E1 that will return "No" in this case, meaning that

I am trying to build an array formula that will count the number of unique
values in Col D subject to the value in ColA="Directed", ColB=60, ColC=285.
Is it possible ?
Thank you in advance.

Under Page Setup, Print Titles, Select columns to repeat at left:  I tried to
select noncontiguous columns, but got error.  Can this be done successfully
as I cannot move the columns to a contiguous location due to multi-users of

I want to same the same header/footer for all documents I produce.
I've read a few suggestions on here as to how the change the properties of
the default Workbook template, but just can't getit to work. I have tried
saving an .xlt file as Book.xlt, Sheet.xlt etc under the XLStart ...

How do I eliminate the 0 before a decimal point as in $ 0.49?

Hi can anyone tell me please, why this formula:
=ROUND(7/(C3-D3),5)
gives an incorrect answer, when I extend it to:
=IF(AND(ISNUMBER(C3),ISNUMBER(D3),C3-D3<>0),IF(ROUND(7/(C3-D3),5)>0.5,C3,""),"")

I have a spreadsheet set as such,
Columns
A = Date
B = Employee (B2 THRU B116 , Column to house formula)