Data downloaded with green triangle(indentation)
 

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

Data downloaded with green triangle(indentation)
 

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?

Data downloaded with green triangle(indentation)
 

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?

Data downloaded with green triangle(indentation)
 

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

"dplatz" wrote:

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?

Data downloaded with green triangle(indentation)
 

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?