Importing text files with Hex values into Calc

I have a text file with hundreds of hexadecimal values in a column like


Most of these values import fine into Calc as text which is how I want them.

However values like 1e4 and 2e9 and similar come in interpreted as if the ‘e’ were “exponent” instead of hex.
For ex, 1e4 appears after pasting/importing expanded as 10000 and 2e9 as 2000000000.

I’ve tried various combinations of import, copy-and-paste, paste special, etc but they always appear as as an expanded number. Is there any way to use Calc to import this data as I want?

In the import dialog select the column and set it to type Text.

Selecting the column is the secret. Thanks.