+ Reply to Thread
Results 1 to 3 of 3

Converting a Text Format Field from M10235 to M000010235

  1. 07-10-2014, 02:39 PM #1
    HospitalOfficer
    HospitalOfficer is offline
    Registered User
    Join Date
    04-30-2014
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    10

    Converting a Text Format Field from M10235 to M000010235

    I am using excel to compare data from one spreadsheet to another. However my utility is not capturing identical matches since one worksheet eliminated the leading 0s while the next worksheet includes all 0s. Our system should actually have the 0s to identify the data correctly.

    Worksheet 1
    M10235

    Worksheet 2
    M000010235


    I would like to convert Worksheet 1 to show M10235 in the format M000010235 so that the number contains the prefix M followed by nine digits.

    Any assistance would be appreciated.
    Reply With QuoteRegister To Reply
  2. 07-10-2014, 02:55 PM #2
    RudiS
    RudiS is offline
    Valued Forum Contributor
    Join Date
    07-04-2012
    Location
    Cape Town, RSA
    MS-Off Ver
    Office 365 ProPlus
    Posts
    1,050

    Re: Converting a Text Format Field from M10235 to M000010235

    Give this formula a try:
    Assume the list of numbers starts in A2...

    =REPLACE(A2,1,1,"M0000")
    Regards,
    Rudi
    Reply With QuoteRegister To Reply
  3. 07-10-2014, 02:56 PM #3
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Converting a Text Format Field from M10235 to M000010235

    How about:

    Please Login or Register  to view this content.
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    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)

Similar Threads

  1. converting text to dates when the text is in a different regional date format
    By Logg in forum Excel General
    Replies: 0
    Last Post: 01-30-2013, 07:05 PM
  2. [SOLVED] Converting columns to Text format....
    By JasonLeisemann in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2013, 07:23 PM
  3. converting date format to text format
    By membership in forum Excel General
    Replies: 4
    Last Post: 03-17-2010, 03:24 AM
  4. Converting Text Field to Time
    By A P in forum Excel General
    Replies: 7
    Last Post: 03-15-2005, 06:06 AM
  5. converting numbers to text and prefill text field with 0's
    By Jan Buckley in forum Excel General
    Replies: 2
    Last Post: 01-20-2005, 05:06 PM

Tags for this Thread

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