Sorry for the vague description. For those interested, I found the
answer in another post. To get all imported text/string values back to
their formats simply copy a blank cell to the imported values and
pastespecial with xlpastevalues and xlpastespecialoperationadd. That
does the trick.

Regards,

Stefano