 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008how can i stop formulas from displaying like this =R[-49]C+R[-25]
it should look like =sUM(a1:a3), without all the brackets etc. Click Tools > Options > General tab Uncheck "R1C1 reference style" > OK  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > it should look like =sUM(a1:a3), without all the brackets etc. If you make the change below you will also experience the following change: The column headings in your spreadsheet will change from numbers to the Excel default of letters. > Click Tools > Options > General tab > Uncheck "R1C1 reference style" > OK > > it should look like =sUM(a1:a3), without all the brackets etc. > The column headings in your spreadsheet will change from numbers to the > Excel default of letters. Of course, that is what I believe the OP wants .. SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.