Cease Excel's "formula making"

B

Buff

I am writing a research article and I'm using Excel to create my results
tables. In order to indicate significant findings I need to include a three
digit number followed by two * symbols. Currently when I try this Excel
assumes I am trying to create a formula of some kind. How can I display
-0.817** in a cell just as I've typed it here? Thanks for the help.
 
P

Peo Sjoblom

You got 2 answers to your previous post, the only way I can replicate that is
by
checking transition formula entry under tools>options>transition So I assume
you have that checked, uncheck it

Regards,

Peo sjoblom
 
O

Otto Moehrbach

Precede your entry with an apostrophe or format the cell to Text BEFORE you
type in the entry. HTH Otto
 
Top