Changing positive to negative in cell...

[donnajay]

I have seen a bunch of formulas but I am not sure that is what I am looking for.

I am manually taking a report off PDF and placing page info in excel, then text to colums to get it separated.

Date Description Code Amount
1/1/2011 Charge 12345 25.00-
1/1/2011 Charge 45678 100.00-
etc.

The column that is in excel with my dollar amount is picking up the negative as 25.00- which is not correct for excel it needs to be -25.00.

Is there a way to choose the cells and convert all of them over to the correct format?

Once again, I thank you for your time!

 

[Jonmo1]

In Step 3 of the Text To Columns,
Click Advanced, and put a check on "Trailing minus for negative numbers"


Hope that helps.

 

[Ron Coderre]

In the 3rd screen of Text-to-Colums
• Select the column that contains numbers
• Check: the Advanced button
...Check: Trailing minus for negative numbers
...Click: OK
...Click: Finish

Does that help?

 

[donnajay]

I have already passed that point now, everything is in excel Is there anything i can do now? I have over 700 lines. if not I will have to redo again.....

Thanks for the quick response...

 

[Jonmo1]

You can do text to columns again, on just the amount column.
And checking "trailing minus for negative numbers" on the 3rd step.

 

[donnajay]

YAY!

Thank you thank you thank you!