LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default Bracket {..} in formulas

I encountered a formula in a spreadsheet which starts and ends with {=...}
these brackets. The formula refers sum (although in reality it is sumproduct)
The brackets are visible in the formula bar, but not in the cell when I
double click it. When I click in the formula bar the brackets disappear and
the formula stops working. It is not possible to copy this back from the
original workbook. When typing it back the formula become ordinary text.
--
milet
 
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
basketball bracket tonyalt3 Excel Worksheet Functions 5 March 16th 09 10:01 PM
Need Help with Bracket system steve_ojapan Excel Discussion (Misc queries) 0 February 1st 08 10:38 PM
How do I bracket a column of numbers? Dididdle Excel Discussion (Misc queries) 0 April 23rd 07 10:44 PM
World Cup bracket help upper90 Excel Discussion (Misc queries) 4 June 2nd 06 09:47 PM
The Draw Menue "bracket" FLKULCHAR Excel Discussion (Misc queries) 1 November 26th 04 01:20 PM


All times are GMT +1. The time now is 02:53 AM.

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

About Us

"It's about Microsoft Excel"