Nope. It was added in xl2002 (I think).

But can you use a macro?

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

SCGRL wrote:

"trailing minus" - option is it available on excel 2000? if so do I have to
turn on..I do not have it under "Advance"

Thank you.

"Gord Dibben" wrote:

DataText to ColumnsNextNextAdvanced.

Make sure "trailing minus" is enabled then Finish.


Gord Dibben MS Excel MVP

On Thu, 17 Apr 2008 05:52:03 -0700, Karin
wrote:

How to change an amount, 523- to -523 in an easy way?



--

Dave Peterson