+ Reply to Thread
Results 1 to 3 of 3

Converting Text to Number

  1. #1
    Registered User
    Join Date
    07-06-2014
    Location
    India
    MS-Off Ver
    2007
    Posts
    73

    Converting Text to Number

    Some times we have may have to work on large database and find that some of the data is still stored as "Text" even if we format entire range to Numeric by selecting entire range.

    When we select such cell, window pops up and says "The number in this cell is formatted as as text or preceded by an apostrophe". We can convert these cells to Numbers by selecting drop down menu.

    Question here is that when working on large data and having such cells in between, it becomes very difficult to convert each and every such cell to numbers.

    Is there any simple way to format entire Range as "Numeric" including above type of cells and not converting one by one. sample file attached..

    Regards,

    Kundanlal
    Attached Files Attached Files

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,576

    Re: Converting Text to Number

    1. Select some blank cell and copy
    2. Select desired range or whole row/column with your numbers
    3. Right click -> Paste special
    4. Choose Add and click OK

  3. #3
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Converting Text to Number

    or
    Select entire column then click on
    Data > Text to Columns > then click finish with out clicking any other options
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Converting text number to a number in a formula...
    By Tommy1115 in forum Excel General
    Replies: 2
    Last Post: 03-24-2016, 05:49 AM
  2. [SOLVED] converting text to a number
    By hk4kim in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-07-2013, 09:35 AM
  3. [SOLVED] Converting a number to text
    By Fishenguy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-23-2012, 11:52 AM
  4. Converting text into number
    By Mula in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-27-2009, 07:48 AM
  5. converting text to number
    By Anat in forum Excel General
    Replies: 5
    Last Post: 02-23-2006, 04:30 PM
  6. converting from text to number
    By james in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2005, 12:06 AM
  7. Converting text to a number
    By Helen Black in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-19-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1