When chosen Excel as XML publisher output, text with prefix Zero’s will be converted to number in excel output.
To maintain the format there are two options.
OPTION 1
Change xml tag in template from
OPTION 2
Add NONBREAKING SPACE before the column.
Place cursor in front of the column you need press CTRL + SHIFT + SPACE. You can also choose this from menu.
Insert - Symbol - Special Characters.
To maintain the format there are two options.
OPTION 1
Change xml tag in template from
OPTION 2
Add NONBREAKING SPACE before the column.
Place cursor in front of the column you need press CTRL + SHIFT + SPACE. You can also choose this from menu.
Insert - Symbol - Special Characters.
3 comments:
Hi Rafi very interesting tip, I'm going to check out this, I always had this problem, tks for help
Thanks it worked .
Another option :
Thanks for the quick tip :-)
Post a Comment