How to keep leading zeros in an Excel file without affecting the other rows

[angeliquec]

Hello,

I have this table:

Row               Product_Code

1                    1234

2                    01234

I want to export this table into excel, maintaining the leading zeroes. I've used style(column)={tagattr='00000'} in the proc report code. Though it maintains the value of the product_code of row 2, it affects the product_code of row 1 as well. How can I prevent the other rows (with lengths less than 5) from having unnecessary leading zeros after export?

Thank you!

[SASKiwi]

There are a number of SAS notes and papers on this issue including these:

http://support.sas.com/kb/38/105.html

http://support.sas.com/resources/papers/proceedings11/266-2011.pdf

[Ksharp]

000000

-->

#####0

[angeliquec]

Thank you for the responses!

But I found the code which also works with proc report -- {tagattr='Format:@'}

https://communities.sas.com/t5/ODS-and-Base-Reporting/Maintain-leading-zeros-in-ExcelXP-output/td-p/...