software

Hello,
I have a multi sheet workbook that I grouped the sheets to copy a formula
through out. When I do this the formula looks like this [R2]*-1 in each cell.
I looked at the referencing and all is correct. I looked at the tools options
for the cell referencing and tried that option but it still did not compute
my formulas.

Any ideas.
Thank you.
Lou

Is it really quot;[R2]quot; etc or is it quot;=[R2]quot; etc

--
Kind regards,

Niek Otten

quot;Louquot; gt; wrote in message
...
gt; Hello,
gt; I have a multi sheet workbook that I grouped the sheets to copy a formula
gt; through out. When I do this the formula looks like this [R2]*-1 in each
gt; cell.
gt; I looked at the referencing and all is correct. I looked at the tools
gt; options
gt; for the cell referencing and tried that option but it still did not
gt; compute
gt; my formulas.
gt;
gt; Any ideas.
gt; Thank you.
gt; Lou
Sorry, I think it was quot;=[R2]*-1

Thank you,
Lou

quot;Niek Ottenquot; wrote:

gt; Is it really quot;[R2]quot; etc or is it quot;=[R2]quot; etc
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Louquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt; I have a multi sheet workbook that I grouped the sheets to copy a formula
gt; gt; through out. When I do this the formula looks like this [R2]*-1 in each
gt; gt; cell.
gt; gt; I looked at the referencing and all is correct. I looked at the tools
gt; gt; options
gt; gt; for the cell referencing and tried that option but it still did not
gt; gt; compute
gt; gt; my formulas.
gt; gt;
gt; gt; Any ideas.
gt; gt; Thank you.
gt; gt; Lou
gt;
gt;
gt;

Is this what you see in the cell or just in the formula bar?

If you see it in the cell, two possibilities:
a. Toolsgt;Optionsgt;View, uncheck quot;Formulasquot; or
b. Your cells were formatted as text before entering the functions. Format
the cells as General. Then do a Find and replace all quot;=quot; by quot;=quot;

Check Toolsgt;Optionsgt;Calculation tab, Automatic

--
Kind regards,

Niek Otten

quot;Louquot; gt; wrote in message
...
gt; Sorry, I think it was quot;=[R2]*-1
gt;
gt; Thank you,
gt; Lou
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; Is it really quot;[R2]quot; etc or is it quot;=[R2]quot; etc
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Louquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hello,
gt;gt; gt; I have a multi sheet workbook that I grouped the sheets to copy a
gt;gt; gt; formula
gt;gt; gt; through out. When I do this the formula looks like this [R2]*-1 in each
gt;gt; gt; cell.
gt;gt; gt; I looked at the referencing and all is correct. I looked at the tools
gt;gt; gt; options
gt;gt; gt; for the cell referencing and tried that option but it still did not
gt;gt; gt; compute
gt;gt; gt; my formulas.
gt;gt; gt;
gt;gt; gt; Any ideas.
gt;gt; gt; Thank you.
gt;gt; gt; Lou
gt;gt;
gt;gt;
gt;gt;