You can click the "Decrease Indent" button on the Formatting
toolbar, or you an use VBA

Sub AAA()
Selection.IndentLevel = 0
End Sub


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


"dplatz" wrote in message
...
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?