View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default @ symbol in field

Enter it like this

'@

You not see the ' in the cell

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"dudemanmax" wrote in message ...
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