converting copied data to numbers in excel xp

I tryed following the instructions for converting text to numbers and it
didn't work.
I am sure someone has had this problem. Any help appreciated.

thanks,

kris

Hi Kris

Have you try this

Copy a empty cell
Select the cells with text values
Right click on the selection
Choose Paste Special ..... Add
OK
ESC



--
Regards Ron de Bruin
http://www.rondebruin.nl



"knutsenk" <knutsenk@discussions.microsoft.com> wrote in message news:76657387-710D-4387-B616-C29AB3EAD360@microsoft.com...
>I tryed following the instructions for converting text to numbers and it
> didn't work.
> I am sure someone has had this problem. Any help appreciated.
>
> thanks,
>
> kris

Kris

If Ron's method does not do the job, perhaps you have some junk in the cells.

Extra spaces, non-breaking spaces to name a couple.

Depends upon where the text is imported from.

Post back if that is the case.


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" <rondebruin@kabelfoon.nl>
wrote:

>Have you try this
>
>Copy a empty cell
>Select the cells with text values
>Right click on the selection
>Choose Paste Special ..... Add
>OK
>ESC
>
>
>
>--
>Regards Ron de Bruin
>http://www.rondebruin.nl
>
>
>
>"knutsenk" <knutsenk@discussions.microsoft.com> wrote in message news:76657387-710D-4387-B616-C29AB3EAD360@microsoft.com...
>>I tryed following the instructions for converting text to numbers and it
>> didn't work.
>> I am sure someone has had this problem. Any help appreciated.
>>
>> thanks,
>>
>> kris

Thanks for the assistance Ron, however that did not work either. I am
attaching a couple of numbers from the sheet I am trying to convert.

3
5
16
11
24

I tried copying these back from here to the Excel sheet, matching
destination, and then the multiply solution worked. So I will copy out of the
worksheet into another application and back again. However, I often need to
do this so if you have an easier method I am all ears. Thanks in advance for
your help.

Kris Knutsen

"Gord Dibben" wrote:

> Kris
>
> If Ron's method does not do the job, perhaps you have some junk in the cells.
>
> Extra spaces, non-breaking spaces to name a couple.
>
> Depends upon where the text is imported from.
>
> Post back if that is the case.
>
>
> Gord Dibben Excel MVP
>
> On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" <rondebruin@kabelfoon.nl>
> wrote:
>
> >Have you try this
> >
> >Copy a empty cell
> >Select the cells with text values
> >Right click on the selection
> >Choose Paste Special ..... Add
> >OK
> >ESC
> >
> >
> >
> >--
> >Regards Ron de Bruin
> >http://www.rondebruin.nl
> >
> >
> >
> >"knutsenk" <knutsenk@discussions.microsoft.com> wrote in message news:76657387-710D-4387-B616-C29AB3EAD360@microsoft.com...
> >>I tryed following the instructions for converting text to numbers and it
> >> didn't work.
> >> I am sure someone has had this problem. Any help appreciated.
> >>
> >> thanks,
> >>
> >> kris
>
>

knut

Download Chip Pearson's CELLVIEW add-in from

http://www.cpearson.com/excel/CellView.htm

Load through Tools>Add-ins.

Select the data and Chip's add-in will show you what the characters in the
cells are.

You may be able to clear them using TRIM or CLEAN.

Most likely David McRitchie's TRIMALL macro will be of greatest assistance.
Cleans up what TRIM and CLEAN miss.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben Excel MVP

On Sat, 2 Apr 2005 15:35:02 -0800, "knutsenk"
<knutsenk@discussions.microsoft.com> wrote:

>Thanks for the assistance Ron, however that did not work either. I am
>attaching a couple of numbers from the sheet I am trying to convert.
>
> 3
> 5
> 16
> 11
> 24
>
>I tried copying these back from here to the Excel sheet, matching
>destination, and then the multiply solution worked. So I will copy out of the
>worksheet into another application and back again. However, I often need to
>do this so if you have an easier method I am all ears. Thanks in advance for
>your help.
>
>Kris Knutsen
>
>"Gord Dibben" wrote:
>
>> Kris
>>
>> If Ron's method does not do the job, perhaps you have some junk in the cells.
>>
>> Extra spaces, non-breaking spaces to name a couple.
>>
>> Depends upon where the text is imported from.
>>
>> Post back if that is the case.
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin" <rondebruin@kabelfoon.nl>
>> wrote:
>>
>> >Have you try this
>> >
>> >Copy a empty cell
>> >Select the cells with text values
>> >Right click on the selection
>> >Choose Paste Special ..... Add
>> >OK
>> >ESC
>> >
>> >
>> >
>> >--
>> >Regards Ron de Bruin
>> >http://www.rondebruin.nl
>> >
>> >
>> >
>> >"knutsenk" <knutsenk@discussions.microsoft.com> wrote in message news:76657387-710D-4387-B616-C29AB3EAD360@microsoft.com...
>> >>I tryed following the instructions for converting text to numbers and it
>> >> didn't work.
>> >> I am sure someone has had this problem. Any help appreciated.
>> >>
>> >> thanks,
>> >>
>> >> kris
>>
>>

Sometimes this works.........

Highlight the column, Data > Text to Columns > Delimited > Next > and
un-check all delimiters > Finish

Vaya con Dios,
Chuck, CABGx3



"knutsenk" <knutsenk@discussions.microsoft.com> wrote in message
news:78AF5A69-709D-4A7E-8EFC-9E8B1C1293F1@microsoft.com...
> Thanks for the assistance Ron, however that did not work either. I am
> attaching a couple of numbers from the sheet I am trying to convert.
>
> 3
> 5
> 16
> 11
> 24
>
> I tried copying these back from here to the Excel sheet, matching
> destination, and then the multiply solution worked. So I will copy out of
the
> worksheet into another application and back again. However, I often need
to
> do this so if you have an easier method I am all ears. Thanks in advance
for
> your help.
>
> Kris Knutsen
>
> "Gord Dibben" wrote:
>
> > Kris
> >
> > If Ron's method does not do the job, perhaps you have some junk in the
cells.
> >
> > Extra spaces, non-breaking spaces to name a couple.
> >
> > Depends upon where the text is imported from.
> >
> > Post back if that is the case.
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Sat, 2 Apr 2005 09:33:58 +0200, "Ron de Bruin"
<rondebruin@kabelfoon.nl>
> > wrote:
> >
> > >Have you try this
> > >
> > >Copy a empty cell
> > >Select the cells with text values
> > >Right click on the selection
> > >Choose Paste Special ..... Add
> > >OK
> > >ESC
> > >
> > >
> > >
> > >--
> > >Regards Ron de Bruin
> > >http://www.rondebruin.nl
> > >
> > >
> > >
> > >"knutsenk" <knutsenk@discussions.microsoft.com> wrote in message
news:76657387-710D-4387-B616-C29AB3EAD360@microsoft.com...
> > >>I tryed following the instructions for converting text to numbers and
it
> > >> didn't work.
> > >> I am sure someone has had this problem. Any help appreciated.
> > >>
> > >> thanks,
> > >>
> > >> kris
> >
> >