If I type (75) for minus 75 the number always appears -75 and not (75). Even
in  'Format cells' the brackets option for minus numbers is not an option.
How can I show minus numbers in brackets?

I have a workbook that contains several tabs named by years (eg Y2001,
Y2002, Y2003...).
Is there a syntax that would reference a cell whose worksheet is based
on the result of a formula?  So, for example, if the formula resulted

I have combined a number of individual files into one workbook by using "Move
or Copy Sheet".  Some of these sheets had macros and defined names and I am
in the process of consolidating all of these into the new workbook.  Every
time I open the new workbook, it indicates that ...

I have an Excel (.xls) file. It opens very slowly on other PC's (to the tune
of seven to ten minutes). I'll try to give the information:
- It's 3.5 mb
- it has 245 worksheets

I've asked about this several times and apologize for asking again but I
don't know what else to do.  I have a 20,000 kb workbook that has several
modules and worksheet applications.  Everytime I use this sheet the first
time I save it takes anywhere from 3-5 minutes.  I've tried ...

While searching the discussion group for a solution to overcome the
conditional formatting limit of 3, I found an entry by Gord Dibben. It is a
source code entry that I was hoping would change the color of the text to the
given value when my VLOOKUP returned certain results.

I am trying to share files with other users within my (school) building.  I
have set several settings like print area, page setup (i.e. scaling) and view
(i.e. print preview).  Is there a way to share those settings too.  I am
working in Excel 2007 but saving the file in 98-2003 ...

Hello    I'm reposting a question a little different.  Here we go  this is my
simple formula  
=VLOOKUP(A1,Sheet1!$A$1:$D$200,4, IF(Sheet1!B1="Fax",4,FALSE)) and this
works  now I want to add if is error equal 0  

I have a snippet of a code shown below, when
c.value=3 and c1.value= "Cluster 3", i is still showing zero. I can't
figut=re out what is going on here. The only thing I noticed is that c.values
are double and c1.values are strings. I don't know if that makes any

I am currently using Excel 2003.  
My budget worksheets consist of 10 workbooks which all have cells linked to
each other.  (exa:  Salaries links to Employees which links to Resource which
links to Summary).  I start with a file folder for 07_08 in which I create a

I'm trying to paste grouped information that has been collapsed and I just
want to see the collapsed data. However it is expanding all the data. Is
there any way of just seeing the collapsed data only? I have tried all the
paste special options too.

Hi!
Is it possible?
For example, lets say in A2 of sheet #1 the data entered in
the cell is "ABC Computer Supplies, 123 Main Street, Akron

Let's Suppose i gave some date 01-01-2007 in cell A1 and 01-05-2010 in cell b1
if i Subtract Cell B1 from A1 so the Answer will be 1100 Days BUT
i want these days as date like 6 days 1 months and 3 Years
OR

I'm getting a very annoying Unprotect Sheet box everytime I save a workbook
that has a saved sheet. So if I have 5 sheets with protection I get 5
different boxes to cancel. Is there a way to disable this message or let me
know what is causing the unprotect sheet box to appear.