Cease Excel's "formula making"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 tools>options>transition So I assume
you have that checked, uncheck it

Regards,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to I use ** without Excel thinking I want to type a formula? 2
Greater Than Symbols and calculations 0
Excel Count If Formula Question 1
time-sensitive color changing cell formula 1
Formula result not displaying correctly 2
What is "--" in Excel Formula (SUMPRODUCT) 2
Creating formula in Excel 4
Formula Audit mode active in one column only; cannot kill. 2

Back
Top