=Table1[[#This Row],[QTY.]]-Table1[[#This Row],[NUMBER]]

I would like to change the above to the good old =a1-b1 format.

I've looked all thru the Microsoft help and searched the Excel threads w/o
success.

Also, does the Tools/Options still exist? Can't find it.

If you convert your table to a range doesn't that do it? (Table Tools,
Convert To Range).

Excel Options are gotten to via the button in the lower right corner of the
Office menu.

--
Jim
"Thumbpick" wrote in message
...
| =Table1[[#This Row],[QTY.]]-Table1[[#This Row],[NUMBER]]
|
| I would like to change the above to the good old =a1-b1 format.
|
| I've looked all thru the Microsoft help and searched the Excel threads w/o
| success.
|
| Also, does the Tools/Options still exist? Can't find it.

Thanks for the quick reply, Jim.

It was partially successful. what I'm getting now is:

=Sheet1!$P11*Sheet1!$I11

Is it possible to get rid of the Sheet reference? Also, thanks for the info
on finding tools. I looked there in Formulas to see if there was a box I
could check but found nothing.

"Jim Rech" wrote:

If you convert your table to a range doesn't that do it? (Table Tools,
Convert To Range).

Excel Options are gotten to via the button in the lower right corner of the
Office menu.

--
Jim
"Thumbpick" wrote in message
...
| =Table1[[#This Row],[QTY.]]-Table1[[#This Row],[NUMBER]]
|
| I would like to change the above to the good old =a1-b1 format.
|
| I've looked all thru the Microsoft help and searched the Excel threads w/o
| success.
|
| Also, does the Tools/Options still exist? Can't find it.

Is it possible to get rid of the Sheet reference?

Find/replace?

--
Jim
"Thumbpick" wrote in message
...
| Thanks for the quick reply, Jim.
|
| It was partially successful. what I'm getting now is:
|
| =Sheet1!$P11*Sheet1!$I11
|
| Is it possible to get rid of the Sheet reference? Also, thanks for the
info
| on finding tools. I looked there in Formulas to see if there was a box I
| could check but found nothing.
|
| "Jim Rech" wrote:
|
| If you convert your table to a range doesn't that do it? (Table Tools,
| Convert To Range).
|
| Excel Options are gotten to via the button in the lower right corner of
the
| Office menu.
|
| --
| Jim
| "Thumbpick" wrote in message
| ...
| | =Table1[[#This Row],[QTY.]]-Table1[[#This Row],[NUMBER]]
| |
| | I would like to change the above to the good old =a1-b1 format.
| |
| | I've looked all thru the Microsoft help and searched the Excel threads
w/o
| | success.
| |
| | Also, does the Tools/Options still exist? Can't find it.
|
|
|