Cease Excel's "formula making"
 

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.

Hi

Format cell/column as text before.

Arvi Laanemets


"Buff" wrote in message
...
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.

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

Regards,

Peo sjoblom

"Buff" wrote:

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.

Precede your entry with an apostrophe or format the cell to Text BEFORE you
type in the entry. HTH Otto
"Buff" wrote in message
...
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.