How to I use ** without Excel thinking I want to type a formula?
 

I am using Excel (Office 2003) to create a table and I need to use two of
these: * to indicate significant results for a research study. How do I tell
Excel that I just want to display this symbol after a three digit number
without it thinking I want to type a formula?

Turn off Lotus transition under toolsoptionstransition and uncheck
transition formula entry


Regards,

Peo Sjoblom

"Buff" wrote:

I am using Excel (Office 2003) to create a table and I need to use two of
these: * to indicate significant results for a research study. How do I tell
Excel that I just want to display this symbol after a three digit number
without it thinking I want to type a formula?

start with an apostrophe '**
or preformat the range as Text.



Buff wrote:

I am using Excel (Office 2003) to create a table and I need to use two of
these: * to indicate significant results for a research study. How do I tell
Excel that I just want to display this symbol after a three digit number
without it thinking I want to type a formula?

--

Dave Peterson