I'm trying to make a pivot table based on an external data source. The source is a txt-file with trailing minus. When I read this file into a pivot table is this number not converted to a "normal" number.

This is possible to handle when one import a txt-file into Excel using "Text to columns", but as I see it not with Pivot table. Do any of you know how I can import a file like this to be readable in a pivot table.