Data downloaded with green triangle(indentation)

[dplatz]

How do I format cells to get rid of a green triangle in the cell?

 

[Chip Pearson]

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]

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

 

[lk]

Format > Cells, select the Alignment Tab, reset the "Indent" to zero.

 

[Chip Pearson]

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