removing firsts two numbers from a list of #s

I have a large list of numbers that are, as an example, 20-13-240. I want to
remove the first "20" from each number. Is there a quick way of doing that?

thanks!

Hi

one option,
(on a backup copy of your workbook)

select the data and choose
data / text to columns
choose
fixed width and press next
click on the preview bit after the 20
so you have
20|-13-240
where the | is the line drawn in by excel
click next
then for the
20
choose "do not import"
click in the -13-240 bit
and choose "text"
click FINISH

Cheers
JulieD

"Linny51" <[email protected]> wrote in message
news:[email protected]...
>I have a large list of numbers that are, as an example, 20-13-240. I want
>to
> remove the first "20" from each number. Is there a quick way of doing
> that?
>
> thanks!

Oh duh, Julie ! I can't believe I forgot this! Thanks so much!

"Linny51" wrote:

> I have a large list of numbers that are, as an example, 20-13-240. I want to
> remove the first "20" from each number. Is there a quick way of doing that?
>
> thanks!

Hi Linny

easy to do (forget that is!)

have fun
JulieD

"Linny51" <[email protected]> wrote in message
news:[email protected]...
> Oh duh, Julie ! I can't believe I forgot this! Thanks so much!
>
> "Linny51" wrote:
>
>> I have a large list of numbers that are, as an example, 20-13-240. I
>> want to
>> remove the first "20" from each number. Is there a quick way of doing
>> that?
>>
>> thanks!