View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Simple calculating ...

Robert

Copy the Eval UDF to a general module in your workbook then use Toppers formula.


Gord

On Sat, 28 Apr 2007 18:45:40 +0200, "Robert" wrote:


Hi
thank you for your mail, but this is not what I need.
I know for "=" and know how to become 5 (from 2+3)
I do not know how to calculate this:

A B
2+3 5

When I enter 2+3 into A cell, cell B need to display 5, not cell A.


Cell A must look's like this:

2+3 (not 5, but 2+3)
and cell B
5

Maybe I am not clear enough?