View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default extremely funny formulae

Try F3
This should bring up a list of defined names

Or for more details
Insert - Names - Define...
There you'll find connie, don, lucky
click on them and you'll see the value associated with them.

Steve

On Wed, 24 Jan 2007 08:02:01 -0000, anthony
wrote:

i have a worksheet in xl2003 that accepts very crazy formulas and gives
equally weird answers. for example the following formulaes appear valid

=connie
=don
=lucky

these formulae give results that i dnt understand.
any one ever come across such??
i can send u a screen grab or the full worksheet to your email