using + or -

J

johnny vino

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

Bob Phillips

Precede it by a single apostrophe

'+

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
N

Niek Otten

Format the cells as Text *before* entering the data

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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

Dave F

Format the cells as text. Or put an apostrophe in front of the sign: '+ then
copy and paste as needed.

Dave
 
N

Niek Otten

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

| Format the cells as Text *before* entering the data
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
||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.
|
|
 
J

johnny vino

Ding! Ding! Ding!

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

Thanks!
 
Top