I need to import XML files to Excel book, but got one issue: Excel convert some number values to date. It happens when numbers are separated with dot or hyphen. The "dot problem" is solved (i changed system separator to comma), but hyphen still makes trouble.
Example: XML file code:
<?xml version="1.0" encoding="UTF-8"?> <Order> <Head> <OrderCode>ZWA00013819</OrderCode> <DateOfShipment>20181231</DateOfShipment> <OrderType>LA </OrderType> </Head> <Detail> <Article>5526-02</Article> <QuantityPC>30</QuantityPC> <PackType>ut</PackType> <DateExpiry>26.12.2019</DateExpiry> </Detail> </Order>
first row - standard import, second - import to row in text format. In both cases excel convert it to date, but i need to keep the number ("5526-02") instead. Could someone please help with this problem? I need to find the way to keep values in the same format as they shown in xml file, desirable without modifying original file.