E
edwardpestian
I have figures that I copy and paste from AS400 into an Excel worksheet.
The figures get pasted as text with a minus sign after the number for
negative values: 2340-. I need to convert these numbers to <2340>
format.
I simply need a formula that says if this range has values with "-" at
the end of the number, then format <xxxx>, otherwise format as +xxxx.
Thanks.
ep
The figures get pasted as text with a minus sign after the number for
negative values: 2340-. I need to convert these numbers to <2340>
format.
I simply need a formula that says if this range has values with "-" at
the end of the number, then format <xxxx>, otherwise format as +xxxx.
Thanks.
ep