topic ExcelXP Leading Zeroes in ODS and Base Reporting

ExcelXP Leading Zeroes

NCNyrk — Mon, 06 Nov 2006 23:31:59 GMT

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?

Re: ExcelXP Leading Zeroes

Eric_SAS — Wed, 08 Nov 2006 15:29:58 GMT

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

What does excel say the format is for your cells?

Re: ExcelXP Leading Zeroes

Chevell_sas — Thu, 09 Nov 2006 14:39:15 GMT

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.