Excel Export Columns with Numbers have Green triangle in the upper-left corner of a cell

Question

Excel Export Columns with Numbers have Green triangle in the upper-left corner of a cell

Welsh Corgi

SSC Guru

Points: 116520
More actions
November 11, 2011 at 7:03 am

#251709

:unsure:I'm Exporting to Excel 2007 and the Columns with Numbers have Green triangle in the upper-left corner of a cell
Per Microsoft:
Green triangle
A green triangle in the upper-left corner of a cell indicates an error in the formula in the cell. If you select the cell, the Trace Error button appears. Click the arrow next to the button for a list of options.
If you select convert to number the green triangle goes away.
I formated the Columns as numeric prior to the load but it did not help. :unsure:
Any help would be appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 1

What datatype has the numeric column in the SSIS dataflow?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

Koen Verbeeck (11/14/2011)
What datatype has the numeric column in the SSIS dataflow?

Converting to a Unicode String [DT_WTSR] in a Data Conversion Task.

Since I posted this believe that it has something to do with the Data. For Zip in some case I have Zip + 4 in others I only have the zip.

Thanks.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 3

Welsh Corgi (11/14/2011)
Koen Verbeeck (11/14/2011)
What datatype has the numeric column in the SSIS dataflow?
Converting to a Unicode String [DT_WTSR] in a Data Conversion Task.
Since I posted this believe that it has something to do with the Data. For Zip in some case I have Zip + 4 in others I only have the zip.
Thanks.

What do you mean with zip + 4?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 4

I should have been more clear and not assumed that everyone was familiar with the US Postal Service (USPS) Zip Code convention.

The USPS has 5 Digit Zip Codes and there are geographical boundaries within a 5 digit zip code that are identified through a 4 digit code.

5 Digit + 4

15766-2323

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Koen Verbeeck SSC Guru Points: 259197 More actions · Answer 5

Welsh Corgi (11/14/2011)
I should have been more clear and not assumed that everyone was familiar with the US Postal Service (USPS) Zip Code convention.
The USPS has 5 Digit Zip Codes and there are geographical boundaries within a 5 digit zip code that are identified through a 4 digit code.
5 Digit + 4
15766-2323
Thanks!

Ah ok, that makes sense 🙂

You have mixed datatypes, so you are exporting strings to Excel.

However, Excel will notice that somes rows are actual numbers, and hence it will give the green triangle as an option to convert those values from string to text.

I don't think there's much you can do (maybe there's some hidden setting in Excel to turn this off?)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP