The SAS Output Delivery System and reporting techniques

ExcelXP Leading Zeroes

Reply
Contributor
Posts: 21

ExcelXP Leading Zeroes

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?
SAS Employee
Posts: 95

Re: ExcelXP Leading Zeroes

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

What does excel say the format is for your cells?
SAS Employee
Posts: 88

Re: ExcelXP Leading Zeroes

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.
Ask a Question
Discussion stats
  • 2 replies
  • 137 views
  • 0 likes
  • 3 in conversation