If using Excel 2002 or 2003 select number cells and DataText to
ColumnsNextNextAdvanced"trailing minus for negative numbers" must be
checked.

Hit Finish


Gord Dibben MS Excel MVP

On Tue, 25 Apr 2006 06:54:01 -0700, cottage6
wrote:

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