View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thumbpick Thumbpick is offline
external usenet poster
 
Posts: 2
Default Excel 2007 - Formula Bar Format

=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.