change 90- to -90 in excel 2000

T

T. Valko

Use text to columns

Select the range in question
Goto the menu Data>Text to Columns
Unless you have made default changes to this wizard all you need to do is
select Finish

Biff
 
D

Dave Peterson

Dana DeLouis posted this:

Sub TrailingMinus()
' = = = = = = = = = = = = = = = =
' Use of CDbl suggested by Peter Surcouf
' Program by Dana DeLouis, [email protected]
' = = = = = = = = = = = = = = = =
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
 
D

Dave Peterson

I think that this was added in xl2002 (and the subject points to xl2k).

(Yeah, it's nice when the details are posted in the body--who reads the subjects
<bg>)
 
T

T. Valko

I've never used Excel 2000. I assumed this was available "way" back then!

I jumped from 97 to 2002. It'll be awhile before I go on to 2007. In fact,
an even newer version will probably come out before I leave 2002.

Biff
 
S

Sandy Mann

If you mean Text to Columns then it is available in XL97. Like Biff I think
that the will be a yet another newer version of XL out before I am able to
upgrade <g>

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
G

Gord Dibben

Text to Columns was available in 97, but not the Advanced>Trailing minus
optionbox within the T to C.


Gord
 
Top