But you'll have to press ENTER; if you press any of the direction keys it will change it to +A2 etc

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" wrote in message ...
| Format the cells as Text *before* entering the data
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "johnny vino" wrote in message ...
||I am having an odd problem.
||
|| I want to populate cells with + or -, but Excel assumes I'm writing a
|| formula and won't allow to just put the character in the cell (unless I hit
|| the spacebar once first, and I don't want to do that)
||
|| Is there a formatting setup that's causeing this? I've searched in vain.
|
|