No it doesn't, you need to add them by committing with Ctrl-Shift-Enter, not
just Enter.

It can be worse if they include {..} in their response as you then have to
remove them. But this is similar to long formulae that extend over multiple
lines, I have to re-join these back in Excel.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" wrote in message
...
sorry I did not frame the question correctly.
what I meant is suppose I get some foirmula from one of the newsgroups and
forgot to download the whole message I would like to know how to
distinguish
the formula. does it mean when I copy the formula in a cell automatically
the curly brackets will appear in the formula bar?




Niek Otten wrote in message
...
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