LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Format in Excel 2007 Larry L. Excel Discussion (Misc queries) 5 July 19th 08 05:45 PM
Save dbase IV and all oldest format with excel 2007 Miguel Jimenez Excel Discussion (Misc queries) 0 June 6th 07 10:36 PM
Converting Lotus 1-2-3 files to Excel 2007 format Clas Excel Worksheet Functions 4 April 18th 07 05:45 AM
Conditional format oddity in Excel 2007 [email protected] Excel Worksheet Functions 4 January 25th 07 08:37 PM
Excel 2007 Date Format Problem terry Excel Discussion (Misc queries) 0 November 25th 06 06:16 AM


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"