Is there a way to do this in excel?

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

"Rizinstk" <(E-Mail Removed)> wrote in message
news:AEB7DC1E-24BD-44AE-AFBF-(E-Mail Removed)...
> Is there a way to do this in excel?

Dana DeLouis posted this:

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

Rizinstk wrote:
>
> Is there a way to do this in excel?

--

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" wrote:
>
> 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
>
> "Rizinstk" <(E-Mail Removed)> wrote in message
> news:AEB7DC1E-24BD-44AE-AFBF-(E-Mail Removed)...
> > Is there a way to do this in excel?

--

Dave Peterson

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

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" wrote:
>>
>> 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
>>
>> "Rizinstk" <(E-Mail Removed)> wrote in message
>> news:AEB7DC1E-24BD-44AE-AFBF-(E-Mail Removed)...
>> > Is there a way to do this in excel?
>
> --
>
> Dave Peterson

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 Removed)
(E-Mail Removed) with @tiscali.co.uk


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" wrote:
>>
>> 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
>>
>> "Rizinstk" <(E-Mail Removed)> wrote in message
>> news:AEB7DC1E-24BD-44AE-AFBF-(E-Mail Removed)...
>> > Is there a way to do this in excel?
>
> --
>
> Dave Peterson

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


Gord

On Fri, 30 Mar 2007 00:37:04 +0100, "Sandy Mann" <(E-Mail Removed)>
wrote:

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