ExcelXP Leading Zeroes

[NCNyrk]

Elsewhere I have seen that it was suggested to use

style={tagattr="\000000"};

to retain leading zeroes in XML. It works fine for 5-or less digits, but when I have a 6-digit number, an extra leading 0 is appearing in Excel:

SAS 234567 --> Excel 0234567

I have also tried style={tagattr="format: @"}; but no leading zeroes are retained in that case.

Any other ideas?

[Eric_SAS]

This works fine for me when I use a format of 00000.

What does excel say the format is for your cells?

[Chevell_sas]

Make sure that you have the downloaded the latest ExcelXP tagset from the ODS Markup page. Using the text format "@" should have worked as well.