ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trailing negatives imported from ASCII file. (https://www.excelbanter.com/excel-discussion-misc-queries/34169-trailing-negatives-imported-ascii-file.html)

Jeanne

Trailing negatives imported from ASCII file.
 
How to I change a column of trailing negatives ie. 123- to (123)?

ScottO

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" wrote in message
...
| How to I change a column of trailing negatives ie. 123- to (123)?



Peo Sjoblom

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Jeanne" wrote in message
...
How to I change a column of trailing negatives ie. 123- to (123)?



Jeanne

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" wrote in message
...
| How to I change a column of trailing negatives ie. 123- to (123)?





All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com