| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data downloaded with green triangle(indentation)
How do I format cells to get rid of a green triangle in the cell?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| How do I eliminate leading zeros from downloaded data? | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| how read data downloaded on cd-rw, now show only code? | New Users to Excel | |||
Linear Mode
