You dont need a macro.

--Select the columns with numbers. From menu DataText to ColumnsNextNext
--From Step 3 of the wizard click 'Advanced'
--Make sure 'Trailing minus for negative numbers' is checked
--Click OKFinish...


--
Jacob (MVP - Excel)


"igbert" wrote:

I have data imported from another file to Excel with negtive numbers show as
478.56- and so on.

Is there a macro to covert all these numbers to a format (478.56)?

Thanks

Igbert