View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default @ symbol in field

Hi,

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

Mike

"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