If I recall correctly, formulas in Lotus 123 started with an @
character, so Excel is treating the @ as some sort of Lotus holdover.
You can type an apostrophe ( ' ) as the first character in the cell to
indicate that what follows is literal text, not to be interpreted in
any way. The apostrophe will not show in the cell, but will show in
the formula bar.

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]



On Sun, 20 Dec 2009 03:06:01 -0800, dudemanmax
wrote:

Excel 2007.

I need to have some cells with a @ character at the start of them. As soon
as I add it and move out of the cells it gives me a "function not valid"
error. I have tried turning off all sorts of autocorrect and other options
to no avail. How can I get that to stop trying to change it and leave it be?

For example I want the cell to say @image