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.