Problem with converting numbers from HEX/DEC file to numeric format

Our take

As an implementation technician for vending machines dispensing PPE, I face a challenge with converting card numbers provided by clients in HEX and DEC formats into an 8-digit numeric format used by our machines. Despite exploring Power Query in Excel and various online converters, I’ve been unable to achieve a successful conversion. I seek guidance on how to accurately transform these values so that employees can seamlessly use their RFID cards to collect necessary items. Any assistance would be greatly appreciated.

I work as an implementation technician for vending machines that dispense PPE (personal protective equipment) in companies. Employees use their RFID cards to collect items by tapping them on the reader installed in the machine.

My problem is that I received card numbers from the client, but they are provided in HEX format (e.g. 000004B00921209) or DEC format (e.g. 3.90845E+11). ChatGPT suggested that they can be converted into the format used by the machine — an 8-digit numeric format — but I’m unable to perform this conversion correctly.

I’ve already tried using Power Query in Excel as well as various online converters, but nothing has worked so far.

I would appreciate any help or guidance on how to properly convert these values.

submitted by /u/BabSa7
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#machine learning in spreadsheet applications#Excel compatibility#Excel alternatives#rows.com#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#HEX#DEC#conversion#numeric format#8-digit#PPE#RFID#vending machines#Power Query#Excel#item dispensing#card numbers