Excel 2007 - Formula Bar Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
| =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
 
Is it possible to get rid of the Sheet reference?

Find/replace?

--
Jim
| 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
| > | > | =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.
| >
| >
| >
 
Back
Top