Converting text to number format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

daveh - 14 Jan 2007 14:47 GMT

I have copied some data down from a web site first into a text file and then
uploaded this into Excel using the tab delimited converter. I cannot convert
the numbers in the colums onto real numbers. I have tried the following:

Excel functions:
Value
Text (thought about converting to text and then number)

I have also cut and paste special the data as "values"
Tried using a multiplication by 1 factor in paste special

Any further thoughts

Thanks

Reply to this Message

Sandy Mann - 14 Jan 2007 14:57 GMT

If you downloaded the *numbers* from the web then the probably have spaces
or non-breaking spaces [Char(160)] attached so try something like

=SUM(TRIM(SUBSTITUTE(G17,CHAR(160),"")))

Signature

HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

>I have copied some data down from a web site first into a text file and
>then
[quoted text clipped - 12 lines]
>
> Thanks

Reply to this Message

Rate this thread: