Converting text to numerical values

's Computer Specifications

I have down loaded a spread sheet using excel. Excel is reading the values
as nonnumerical values. How can I convert the numbers into numerical values
the computer can read so I can us the analysis features.

's Computer Specifications

This usually works.

Format all to General.

Copy an empty cell.

Select the range to change and Edit>Paste Special>Add>OK>Esc.

Gord Dibben MS Excel MVP

On Mon, 15 Feb 2010 19:13:01 -0800, J <(E-Mail Removed)> wrote:

>I have down loaded a spread sheet using excel. Excel is reading the values
>as nonnumerical values. How can I convert the numbers into numerical values
>the computer can read so I can us the analysis features.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting numerical value to text	Alojz	Microsoft Access Queries	4	8th Mar 2009 11:47 AM
Converting Numerical values to Words	rgaylo	Microsoft Access	1	28th Nov 2007 10:21 PM
Converting Numerical Values Into Text	cleadavis	Microsoft Excel Misc	0	17th Nov 2004 08:18 PM
Converting Numerical Values Into Text	cleadavis	Microsoft Excel Misc	1	17th Nov 2004 07:49 PM
converting text to numerical value	=?Utf-8?B?Y3JlYXRpdnNwYXJ4?=	Microsoft Excel Worksheet Functions	3	29th Sep 2004 03:10 PM