[SOLVED] I'm trying to familiarize myself with Excel 10 and I've discovered tiny green triangles in the upper corners of nearly all my numbers data that I've chosen to format as "text". ie. part numbers Since it doesn't seem to happen with ALL numeric data formatted as "text" I can't be certain what exactly causes it but it appears to be a warning of some kind.
Also I've been experimenting with "Vlookups" and my success there is also hit and miss (even using the same formula). I've attched a small file illustrating my formulas, formatting and the errors I've earned by doing so.
My hope is that some kind person will have the time to educate me in the error of my ways so that I can avoid these problems in the future.
I'd very much appreciate it!
Bookmarks