@ symbol in field

[dudemanmax]

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

 

[trip_to_tokyo]

Format the cell as text and you will be able to input it.

Pleased hit Yes if my comment has helped.

 

[trip_to_tokyo]

. . so in EXCEL 2007 that would be:-

- Home group

- Font then click on the arrow in the lower right hand corner

- Format Cells should launch

- Number tab

- select Text on the left hand side (by clicking it)

- OK

You should then be able to get @image into the cell.

Please hit Yes if my comments have helped.

Thanks!

 

[Ron de Bruin]

Enter it like this

'@

You not see the ' in the cell

 

[Mike H]

Hi,

Enter an apostrophe ' before you enrte @. It won't show up in the cell.

Mike

 

[Rick Rothstein]

I find it easier to get to the Format Cells dialog box by simply right
clicking the selected cell or cells and picking Format Cells from the popup
menu that appears.

 

[Chip Pearson]

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]