"Function Not Valid" - Getting Rid of the "@" symbol


V

Vienna

Hi,
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.
 
Ad

Advertisements

D

Dave Peterson

Try formatting the cell as text first. Or precede your entry with an
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 @/=)
 
F

Frank Kabel

Hi
enter your text with a preceding apostrophe.e.g.
'@sometext
 
Ad

Advertisements

H

Harlan Grove

Dave Peterson said:
@ 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Symbol function 4
Symbols in Data Validation List 2
Get rid of Duplicates 1
getting rid of blanks 0
Get rid of the zeros?! 5
Get rid of #N/A 1
Get Rid of N/A 6
Get rid of #value! 0

Top