cottage6
or...
=IF(ISNUMBER(B7),B7,---LEFT(B7,LEN(B7)-1))
beege

"cottage6" wrote in message
...
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