+ Reply to Thread
Results 1 to 3 of 3

Convert Text to Number

  1. 01-26-2012, 03:23 PM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Convert Text to Number

    Hello:

    I have excel sheet as attached...
    As you can see Column B has Invoice # (Its in the text form).

    I uually scroll down manually one page at a time and convert Column B text to number.

    I need to know if there is easy way to select whole column to perofrm this task.

    Thanks and help as always appreciated.

    RM
    Attached Files Attached Files
    Last edited by rizmomin; 02-07-2012 at 12:17 AM.
    Reply With QuoteRegister To Reply
  2. 01-26-2012, 03:25 PM #2
    JieJenn
    JieJenn is offline
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Convert Text to Number

    Highlight all the invoices in Col B, go to Data > Click TextToColumns then Hit finish
    Learn Data Analysis or Excel youtube.com/jiejenn
    Reply With QuoteRegister To Reply
  3. 01-26-2012, 06:05 PM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Convert Text to Number

    Thanks a lot for a quick solution...

    Apprciate your help

    RM
    Last edited by rizmomin; 02-07-2012 at 12:16 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1