I have a worksheet with cells linked back to another worksheet in the
same workbook using the formula "='Sheet1!'B2".  The information comes
across, but I'm losing formatting such as left, right, or center,
indents, and line breaks within cells.  Is there a way I can do this

With the following in my sheet...
    A    B    C
1    4
2    5    {=MATCH(5,A2:A2,0)}

Hi.  I'm posting to a Word an an Excel group, because I suspect and
hope the answer is the same but fear it might not be.
At work yesterday I installed Office 2007 (except Outlook) on the
same computer where I had office 2003. I'm still able to open and run

I am using Excel 2002. I would like to create a keyboard shortcut that
would allow me to Center align. The center
icon is "&Center", but Alt C gives me "Clear Print Selection" I
removed the "&" from in front of the clear print icon, but when I do

I have a spreadsheet where if certain cells are empty, I get a divide by 0
errors. I understand I can nopt divide by 0; that is not the issue. My issue
is I can not seem to add a column of numbers if one or more have divide by 0
errors.

references to cells in a different worksheet look like this, e.g.:
='worksheet'!$A$1
In this formula I want to replace 'worksheet' by the value of a cell,
e.g. $B$1, of the current worksheet, in which stand the text

I'm trying to figure out in what way I can sum up the currency values of
select cells in a row based upon alternate select cells having a value that
is not blank.  I'm trying to create a worksheet that will allow our group to
order items and provide totals.  So, if they do not ...

Here's my dilemma:
I have a flat file (example follows):
Orders
          A              B            C

I have a text file that I opened in excel and need to replace some of the
data with new data.  I cannot use the find/replace all function because the
old data is not in a consistent list form.  The data I need to replace is in
column F.  But there is also other info in the same ...

I have a matrice that looks something like this:
       A               B
1       service         1000
2       maintenence     500

Using Excel I formatted cells using fractions as quarters. how can I convert
the 2/4 to 1/2 now?
all of the numbers of my cells now show either 1/4, 2/4 or 3/4. I wanted to
be able to change the 2/4 for 1/2 without having to format each one. Thank

Something I could set up an account with, to keep my post count. For
the last few weeks, the "new posts" have not been updating, so I have
to constantly check each group to see if there are any new msgs or
replies to my posts. I give up!

I have a date, 1/23/2008, in C6 of worksheet "Joe"
I would like to see 1/29/2008 in C6 of worksheet "tom" when I go there. IE
one week later date. Currently just typing it in. No biggie but is there a
better way?

I have a sheet with a column that lists some values. I also have a
second sheet that has a column where the cells are merged every 4
rows. I need to copy the values of the first sheet into the merged
cells, but when I do, I only see every fourth value on the merged

Hi, this is my first post! Need some help with the vlookup formula.
My range is between A1:B8. Colon A represent numbers and colon B
represent names. How can I vlookup colon A for a specific number and
return all names in colon B with that number?