Convert to negative numbers in whole worksheet

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
 
J

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top