Minus symbol appearing at end of number

[Airbiskit]

Just imported a report in to excel from a txt file, in one of the columns the numbers appear with a minus at the end. The minus needs to appear at the front so as to read it properly for calculations.

How can this be changed correctly.

Please help.

Thanks

 

[KenWright]

Try this:-

http://www.mcgimpsey.com/excel/postfixnegatives.html

Regards
Ken.........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[PPettit]

I had the same problem not too long ago.

http://www.tek-tips.com/viewthread.cfm?qid=1169718&page=1