Apologies for not stating the this feature under Text to Columns was introduced
in Excel 2002.

The macro will work in all versions.


Gord

On Thu, 28 Sep 2006 11:45:01 -0700, Lisa wrote:

Thank you. This looked so easy, unfortunately when I went to the advanced
step, my only two choices were decimal separator or thousands separator with
drop down answers. There was nothing that said "trailing minus sign for
negative numbers" I tried both with delimited text and fixed width. Work
computers have excel 2000... would this be the issue?

Gord Dibben MS Excel MVP