Doesn't work in Excel 2000 or Excel 97 at least. (as far as reevaluating
the cells. If you meant to separate the number from the negative sign, that
would be different).
--
Regards,
Tom Ogilvy
"Frank Kabel" wrote in message
...
Hi
try using 'Data - Text to columns' to convert the negative
numbers to rela values
-----Original Message-----
Hi.
I have a problem. When I import a .txt file create by an
accounting
software, where there are negative numbers value in this
format (for
example 150-), after the importation those numbers have a
text format
and I can't sum them with the other numbers. I have a
custom format
(#.##0;#.##0-) but I can't apply it after the importation.
Can you help me?
---
Message posted from http://www.ExcelForum.com/
.