Formula Assistance Financial system export

[toysam]

I have a listing of over 2500 numbers that I exported from our financial
system. Some of the cells have a CR after the number standing for credit
balance instead of a negative. Some of the numbers are positive and have
nothing else in the cell besides the number. How can I change the numbers
with a CR to show paranthesis around the number instead of the CR? I would
be happy to forward you a sample.

We are using Office 2007.

 

[David Biddulph]

=IF(RIGHT(A2,2)="CR",-LEFT(A2,LEN(A2)-2),A2) and format the cell
appropriately, perhaps as
#,##0.00;(#,##0.00)

 

[Daryl S]

Toysam -

Assuming your amounts are in column L, put the following formula in a blank
column. This assumes the first row contains data:
=IF(RIGHT(TRIM(L1),2)="CR",0-VALUE(LEFT(L1,LEN(TRIM(L1))-3)),L1)

When you are done, copy the new column, then you can paste special - values
either back into the new column or if all looks good, back into column L and
then delete the new column.