Trailing negatives imported from ASCII file.

How to I change a column of trailing negatives ie. 123- to (123)?

Go to this site and download the FREE utility add-in. It includes a feature
to do exactly what you want (besides plenty of other useful tools).

http://www.asap-utilities.com/

Rgds,
ScottO

"Jeanne" <Jeanne@discussions.microsoft.com> wrote in message
news:C422E2E4-6A49-412F-B2D9-E28D9AC46572@microsoft.com...
| How to I change a column of trailing negatives ie. 123- to (123)?

Thank you Scott. Works perfect - I found a lot of other uses.

"ScottO" wrote:

> Go to this site and download the FREE utility add-in. It includes a feature
> to do exactly what you want (besides plenty of other useful tools).
>
> http://www.asap-utilities.com/
>
> Rgds,
> ScottO
>
> "Jeanne" <Jeanne@discussions.microsoft.com> wrote in message
> news:C422E2E4-6A49-412F-B2D9-E28D9AC46572@microsoft.com...
> | How to I change a column of trailing negatives ie. 123- to (123)?
>
>
>

http://www.mcgimpsey.com/excel/postfixnegatives.html

--
Regards,

Peo Sjoblom

(No private emails please)


"Jeanne" <Jeanne@discussions.microsoft.com> wrote in message
news:C422E2E4-6A49-412F-B2D9-E28D9AC46572@microsoft.com...
> How to I change a column of trailing negatives ie. 123- to (123)?