Adding the analysis add-in made no difference. It did work for numbers written only in decimal numeric characters. (Hello? Microsoft?) Using HEX2DEC did not work for hex numbers with ABCDEF digits. It seems apparent that there is no way for the user to make Excel "hexidecimal-aware". 00-06-F8-E4-85-7B, without having to manually add the hyphens to each entry. 0006F8E4857B, and my engineers want to convert that to a correctly formatted MAC address, e.g. The MAC addresses come through as hex numbers with no format, e.g. My shop is trying to format MAC addresses from a text dump imported as a. Hello, everyone! I have the same question that JayHertz asked two years ago: How to format MAC addresses in Excel? I have searched Excel Help, the knowledge base, and the Internet without success so far.
0 kommentar(er)
