Convert to Numbers

J

John

I have a column of numbers that I copy from an Internet Banking app. The
numbers are in General format when I paste them into Excel. Each "number" is
in the format "#,###.##-" for withdrawls and "#,###.## " for deposits.

What I want to be able to do is find simple way to convert them to positvie
and negative NUMBERS
 

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

Similar Threads

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Reconciliation... Again 1
count number of unique values in column 8
Macro to copy table of contents to a new doc 0
Embed the same Excel multiple times 0
How to change font & size of (all) citation numbers? 7
converting number to dollar 10

Top