I'm transferring a file from Mainframe into Excel where I can manipulate the
data. Everything was working just great until I realized to my shock and
dismay, that negative numbers in Mainframe are (ex.) 16- instead of -16,
which means they are formatted as text when they import into the spreadsheet.
I've tried everything I can think of to format these numbers as values
without success. Any ideas besides re-keying the numbers which I really
don't want to do? TIA