Thanks, that got rid of the triangle but the data is still indented. How do I
remove the indentation?

"Chip Pearson" wrote:

You can't do it with formatting. Go to the Tools menu, choose
Options, then the Error Checking tab. There, uncheck "Enable
background error checking".


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


"dplatz" wrote in message
...
How do I format cells to get rid of a green triangle in the
cell?