Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is small green triangle in upper left corner of cell?
I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green triangle in its upper left-hand corner,
and when I click on it the cell to the left (one with apostrophe) displays a message saying "The number in this cell is formatted as text or is preceded by an apostrophe." What is the meaning of the green triangle? Thanks, Don |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is small green triangle in upper left corner of cell?
Thanks for your come back and help. But, I can't find the error checking controls you mention. I'm using Excel 2007. Don On Tue, 13 Oct 2009 16:50:02 -0700, FSt1 wrote: hi, this is an error checker. excel checks for things that it thinks may be an unintentional error by the user and displays the error. if you don't want excel checking for this error then on the menubar toolsoptionserror checking tab uncheck numbers strored as text. you might want to look over the other errors that excel check for. I have about half of the unchecked. Regards FSt1 "Don" wrote: I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green triangle in its upper left-hand corner, and when I click on it the cell to the left (one with apostrophe) displays a message saying "The number in this cell is formatted as text or is preceded by an apostrophe." What is the meaning of the green triangle? Thanks, Don |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is small green triangle in upper left corner of cell?
Click Office Button, the Excel Options, Formulas,....
Don wrote: Thanks for your come back and help. But, I can't find the error checking controls you mention. I'm using Excel 2007. Don On Tue, 13 Oct 2009 16:50:02 -0700, FSt1 wrote: hi, this is an error checker. excel checks for things that it thinks may be an unintentional error by the user and displays the error. if you don't want excel checking for this error then on the menubar toolsoptionserror checking tab uncheck numbers strored as text. you might want to look over the other errors that excel check for. I have about half of the unchecked. Regards FSt1 "Don" wrote: I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green triangle in its upper left-hand corner, and when I click on it the cell to the left (one with apostrophe) displays a message saying "The number in this cell is formatted as text or is preceded by an apostrophe." What is the meaning of the green triangle? Thanks, Don |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is small green triangle in upper left corner of cell?
Thanks, Bob! Appreciate your's and the others help.
Don On Wed, 14 Oct 2009 07:43:37 -0500, Bob I wrote: Click Office Button, the Excel Options, Formulas,.... Don wrote: Thanks for your come back and help. But, I can't find the error checking controls you mention. I'm using Excel 2007. Don On Tue, 13 Oct 2009 16:50:02 -0700, FSt1 wrote: hi, this is an error checker. excel checks for things that it thinks may be an unintentional error by the user and displays the error. if you don't want excel checking for this error then on the menubar toolsoptionserror checking tab uncheck numbers strored as text. you might want to look over the other errors that excel check for. I have about half of the unchecked. Regards FSt1 "Don" wrote: I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green triangle in its upper left-hand corner, and when I click on it the cell to the left (one with apostrophe) displays a message saying "The number in this cell is formatted as text or is preceded by an apostrophe." What is the meaning of the green triangle? Thanks, Don |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is small green triangle in upper left corner of cell?
You're welcome, have a great day.
Don wrote: Thanks, Bob! Appreciate your's and the others help. Don On Wed, 14 Oct 2009 07:43:37 -0500, Bob I wrote: Click Office Button, the Excel Options, Formulas,.... Don wrote: Thanks for your come back and help. But, I can't find the error checking controls you mention. I'm using Excel 2007. Don On Tue, 13 Oct 2009 16:50:02 -0700, FSt1 wrote: hi, this is an error checker. excel checks for things that it thinks may be an unintentional error by the user and displays the error. if you don't want excel checking for this error then on the menubar toolsoptionserror checking tab uncheck numbers strored as text. you might want to look over the other errors that excel check for. I have about half of the unchecked. Regards FSt1 "Don" wrote: I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green triangle in its upper left-hand corner, and when I click on it the cell to the left (one with apostrophe) displays a message saying "The number in this cell is formatted as text or is preceded by an apostrophe." What is the meaning of the green triangle? Thanks, Don |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is small green triangle in upper left corner of cell?
And the specific message you are receiving indicates that you will be unable
to perform mathematical calculations with this cell unless you convert it to number. "FSt1" wrote: hi, this is an error checker. excel checks for things that it thinks may be an unintentional error by the user and displays the error. if you don't want excel checking for this error then on the menubar toolsoptionserror checking tab uncheck numbers strored as text. you might want to look over the other errors that excel check for. I have about half of the unchecked. Regards FSt1 "Don" wrote: I have a text cell containing text with an apostrophe, and to the right of it another text cell containing a numeric digit. The right cell has a small green triangle in its upper left-hand corner, and when I click on it the cell to the left (one with apostrophe) displays a message saying "The number in this cell is formatted as text or is preceded by an apostrophe." What is the meaning of the green triangle? Thanks, Don |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the little black triangle in the upper left corner of a cell | New Users to Excel | |||
how do I get rid of the green triangle/upper left cell corner | Excel Discussion (Misc queries) | |||
Green Triangle in Upper Left Corner of Cell | New Users to Excel | |||
green triangle top left corner of cell in Excel | Excel Discussion (Misc queries) | |||
What does a small green triangle in the upper left hand corner of. | Excel Discussion (Misc queries) |