Marc,

This is Excel telling you that you have numbers stored as text. To get rid
of the green triangle:-

Tools|Options - Error Checking tab - Un-check 'numbers stored as text'

Mike

"Marc" wrote:

In my excel sheet there is a General formatted column
When entering numbers in to the column it stores as numbers with aligning
right side
Then I format the entire column as text, after that all values are left
aligned
Then I entered a new value in to the column, it stores with green colour
hyphen
Previously entered values are not like that. If I edit the previously
entered value then that value also stores with green colour hyphen.
What is the reason for this and how to avoid this
Please Help