Remove Green symbol on formatted TEXT cells

[redhatter]

I can't find anything on how to remove the little green
corner on a text cell except one cell at a time. I changed
all cells to a number format and want to remove all green
corners at one time. Is there a way?

 

[RagDyer]

You could try:
<Tools> <Options> <ErrorChecking> tab,
Make sure that "NumberStoredAsText" is *unchecked*.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I can't find anything on how to remove the little green
corner on a text cell except one cell at a time. I changed
all cells to a number format and want to remove all green
corners at one time. Is there a way?

 

[Chip Pearson]

Go to the Tools menu, choose Options, then the Error Checking
tab. There, uncheck the "Enable background error checking" tab
to disable all error checking, or uncheck the "Number stored as
text" option in the Rules section.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com