change 90- to -90 in excel 2000

[Guest]

Is there a way to do this in excel?

 

[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

 

[Dave Peterson]

Dana DeLouis posted this:

Sub TrailingMinus()
' = = = = = = = = = = = = = = = =
' Use of CDbl suggested by Peter Surcouf
' Program by Dana DeLouis, (e-mail address removed)
' = = = = = = = = = = = = = = = =
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

 

[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. 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

 

[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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Gord Dibben]

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


Gord