From: igbert on
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
From: Jacob Skaria on
You dont need a macro.

--Select the columns with numbers. From menu Data>Text to Columns>Next>Next>
--From Step 3 of the wizard click 'Advanced'
--Make sure 'Trailing minus for negative numbers' is checked
--Click OK>Finish...


--
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