View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Stopping an Entry

Actually when I paste the formula into a cell Excel suggests a correction by
adding the missing parens.


Gord

On Thu, 1 Oct 2009 20:40:32 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

If you merely copied and pasted Gord's formula, Excel would have said that
it was invalid and refused to accept it until the formula was changed.