Trailing minus

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.

HI

The following code applies to text starting at "A1" and strips out a trailing minus if it appears and multiplies the result by -1.

Please Login or Register  to view this content.

Regards

Jeff

Thank you for your feedback.

I can't use this method since the text file has more than 100000 lines. It is read as an external source and there must be a conversition before the pivot table. I use excel 2003 and I have the row limitaton there. The VBA code will not run on all lines.

I'm interested. Thank you :-) Please find attached a sample.