What version Gord?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
DataText to ColumnsNextNextAdvanced.

Make sure the "trailing minus etc." option is checked and Finish.


Gord Dibben MS Excel MVP

On Fri, 22 Sep 2006 14:38:02 -0700, james

wrote:

Thanks Dave,

It works great.

James

"Dave Peterson" wrote:

Dana DeLouis posted this:


Sub TrailingMinus()
' = = = = = = = = = = = = = = = =
' Use of CDbl suggested by Peter Surcouf
' Program by Dana DeLouis,
' = = = = = = = = = = = = = = = =
Dim rng As Range
Dim bigrng As Range

On Error Resume Next
Set bigrng = Cells.SpecialCells(xlConstants, xlTextValues).Cells
If bigrng Is Nothing Then Exit Sub

For Each rng In bigrng.Cells
rng = CDbl(rng)
Next
End Sub

If you're new to macros, you may want to read David McRitchie's intro
at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

james wrote:

Hi,

I have a column of numbers. Some of the negative number with negative
sigh
at the end of the number. How to I convert the negative sign from back
of the
number to the front of the number. ( x- - -x)

Thanks

James

--

Dave Peterson