"Function Not Valid" - Getting Rid of the "@" symbol
Vienna
Is there a way I can just type "@sometext" in a cell in
Excel? Every time I do this, I receive an error message
saying "That Function is Not Valid". It seems to
interpret the "@" symbol as some formula shortcut to a
most recently used formula?
Thank you in advance.
Frank Kabel
enter your text with a preceding apostrophe.e.g.
'@sometext
--
Regards
Frank Kabel
Frankfurt, Germany
"Vienna" <anon...@discussions.microsoft.com> schrieb im Newsbeitrag
news:28cd01c47061$93926500$a501...@phx.gbl...
Dave Peterson
apostrophe:
'@sometext
@ was used by Lotus 123 like the leading = sign in xl functions.
=sum(a1:b3)
is equivalent to
@sum(a1..b3)
(And excel wants those Lotus users to convert to excel. So it tries to make
writing formulas easier--and accepts both @/=)
--
Dave Peterson
ec3...@msn.com
Harlan Grove
...
>@ was used by Lotus 123 like the leading = sign in xl functions.
Quibble: @ precedes *ALL* 123 functions. 123 equivaents for Excel's NOW(),
TODAY(), RAND(), PI() are @NOW, @TODAY, @RAND and @PI *without* trailing
empty parentheses. The @ specifies a separate name space, so in 123 it's
perfectly OK to give ranges names like SUM, COUNT, PI, or RAND (not to
mention really dumb names like A1 or X99, which effectively masks those
cells unless qualified with worksheet names).
The leading + was only needed in 123 when the first term in a cell formula
was a cell address or range name. Formulas beginning with number constants,
functions or left parentheses didn't need leading +s.
jingh...@gmail.com
Auric__
> Get out the function.
Jesus Christ, the original post was 16 years ago, and you reply with 4 words
that are EXTREMELY unhelpful. You are a worthless human being.
--
It is often said that before you die your life passes before your eyes.
It is in fact true. It's called living.