PC Review


Reply
Thread Tools Rate Thread

Converting text to numerical values

 
 
J
Guest
Posts: n/a
 
      16th Feb 2010
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.
 
Reply With Quote
 
 
 
 
Gord Dibben
Guest
Posts: n/a
 
      16th Feb 2010
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.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:43 AM.