Thread: using + or -
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
johnny vino johnny vino is offline
external usenet poster
 
Posts: 6
Default using + or -

Ding! Ding! Ding!

There goes my stupid alarm. I was of course using directional keys
exclusively. I knew there was a simple answer.

Thanks!

"Niek Otten" wrote:

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.
|
|