Green triangles

  • Thread starter Thread starter Stevethedoc
  • Start date Start date
S

Stevethedoc

thanks for such a speedy response, teh placement of 1 in cell an
edit,paste special, multiply works, but why?

the value function doesn't work, as the green triangle seems to rende
the contents of the cell as neither number or text. strange.

once again thanks :
 
Happy to help.
Thanks for the feedback.
As to why one works and not the other, maybe Microsoft knows. The Help File
for VALUE might shed some light--it states the formula is provided for
compatibility with other spreadhseet programs only.

tj
 

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

What is small green triangle in upper left corner of cell? 6
what is the geen triangle in a cells with number? 4
How do I eliminate the green triangle throughout my spreadsheet? 4
How do I eliminate the green triangle throughout my spreadsheet? 2
Green triangle - text fields don't match. 2
Stop error checking a cell that has been formatted to text 3
Green Triangles in Cells 3
What are the green triangles, in the upper left corner of a cell. 3

Back
Top