In the formula bar, array formulas appear in curly brackets {}

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R.VENKATARAMAN" wrote in message
...
some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from looking
at
the formulas