Data downloaded with green triangle(indentation)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dplatz - 16 Jun 2006 17:08 GMT

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

Reply to this Message

Chip Pearson - 16 Jun 2006 17:14 GMT

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".

Signature

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

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

Reply to this Message

dplatz - 16 Jun 2006 17:33 GMT

Thanks, that got rid of the triangle but the data is still indented. How do I
remove the 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".
>
> > How do I format cells to get rid of a green triangle in the
> > cell?

Reply to this Message

lk - 16 Jun 2006 17:41 GMT

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

> Thanks, that got rid of the triangle but the data is still indented. How do I
> remove the indentation?
[quoted text clipped - 5 lines]
> > > How do I format cells to get rid of a green triangle in the
> > > cell?

Reply to this Message

Chip Pearson - 16 Jun 2006 17:44 GMT

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

Sub AAA()
Selection.IndentLevel = 0
End Sub

Signature

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

> Thanks, that got rid of the triangle but the data is still
> indented. How do I
[quoted text clipped - 6 lines]
>> > How do I format cells to get rid of a green triangle in the
>> > cell?

Reply to this Message