Plus or Minus
 

I want to be able to type a '+' or a '-' into a cell without initiating a
formula. Can the automatic formula be switched off for some columns?

Plus or Minus
 

Hi Lynn,

As far as I know, "automatic formula can't be switched off for some
columns" but you can get the same effect by formatting the column as
text, eg:
*[alt + o + e], Number - choose text or
*type a single appostrophe before the plus or minus. This forces the
cell to be formatted as text.

hth
Rob Brockett
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=553527

Plus or Minus
 

Thanks for the reply - your second idea may well work. But formatting the
cell as text I had already tried, excel still wants to make the cell a
formula!

"Lynn Moralee" wrote:

I want to be able to type a '+' or a '-' into a cell without initiating a
formula. Can the automatic formula be switched off for some columns?

Plus or Minus
 

Hi Lynn

type a ' sinal before, excel will understand it as an text so '+ or '-

hope this helps
regards from Brazil - going to the 6th *
Marcelo


"Lynn Moralee" escreveu:

I want to be able to type a '+' or a '-' into a cell without initiating a
formula. Can the automatic formula be switched off for some columns?

Plus or Minus
 

hi

try entering + or - and press enter ?

regards

Lynn Moralee wrote:
I want to be able to type a '+' or a '-' into a cell without initiating a
formula. Can the automatic formula be switched off for some columns?

--
bnt

Message posted via http://www.officekb.com

Plus or Minus
 

Thanks, Marcelo - I think this is the only way.
Regards back from England

"Marcelo" wrote:

Hi Lynn

type a ' sinal before, excel will understand it as an text so '+ or '-

hope this helps
regards from Brazil - going to the 6th *
Marcelo


"Lynn Moralee" escreveu:

I want to be able to type a '+' or a '-' into a cell without initiating a
formula. Can the automatic formula be switched off for some columns?

Plus or Minus
 

Thank you, Brian - if only life was so simple. In Excel 2003 typing a plus
triggers off the formula wizard.
Best wishes

"brian thompson3001 via OfficeKB.com" wrote:

hi

try entering + or - and press enter ?

regards

Lynn Moralee wrote:
I want to be able to type a '+' or a '-' into a cell without initiating a
formula. Can the automatic formula be switched off for some columns?

--
bnt

Message posted via http://www.officekb.com

Plus or Minus
 

Hi Lynn,
thanks for the feedback, pleased we could help.

wrt to your response to Brian:
There must a setting somewhere in Excel 2003 that will allow you to
change this response b/c I have 2003 & I can press [+] or [-] and then
[enter] w/o the formula wizard (insert function dialog box) popping up.
I've had a bit of a search through the online help but can't find a
quick response - Goodluck if you go looking :-)

Rob Brockett
Always learning & the best way to learn is to experience...

Lynn Moralee Wrote:
Thank you, Brian - if only life was so simple. In Excel 2003 typing a
plus
triggers off the formula wizard.
Best wishes

"brian thompson3001 via OfficeKB.com" wrote:

hi

try entering + or - and press enter ?

regards

Lynn Moralee wrote:
I want to be able to type a '+' or a '-' into a cell without
initiating a
formula. Can the automatic formula be switched off for some
columns?

--
bnt

Message posted via http://www.officekb.com



--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=553527