Convert to negative numbers in whole worksheet

  • Thread starter Thread starter igbert
  • Start date Start date
I

igbert

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
 
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...
 
Back
Top