Forum Discussion
FILTERXML of number value parses as datetimestamp in Excel2013
Hi all, Today I decided to use the FILTERXML for a new project. Within this project I can get counts per car manufacturer from external XML source. WEBSERVICE in combination with FILTERXML would ...
sappollo I'm encountering the same behaviour and bug in Excel 2016. Furthermore, I tried to utilize =NUMBERVALUE (=ZAHLENWERT in German), which is supposed to allow one to specify customized decimal-characters. However, it seems that =XMLFILTER (=XMLFILTERN in German) parses all numbers beforehand and, therefore, already interprets "1.8" as the first of August and outputs 44044.
This is a really annoying situation. For the mean time, I'm using the same workaround as @sappollo by multiplying everything by 10000 and only using integers in the XML.
Can't reproduce that on 365
