+ Reply to Thread
Results 1 to 3 of 3

Breakdown 4 digit numbers into 2 digit-numbers

  1. #1
    Forum Contributor Jerry HKA's Avatar
    Join Date
    09-25-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    126

    Breakdown 4 digit numbers into 2 digit-numbers

    Hi Guys,

    In a past thread, I have asked and received a working code that helps me breakdown a 4 digit number into 3 digit numbers (refer to the code below).

    Please Login or Register  to view this content.
    Here, I would require a code that breaks down a number into two digit numbers instead of four digit numbers. Please kindly refer to the attached file for an example of my desired results.

    Please also note that I would like the code to apply itself to the whole worksheet.

    Thanks, any help is very much appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Breakdown 4 digit numbers into 2 digit-numbers

    Why will 9989 become:
    99
    98

    and not:
    89
    99

    If second is correct, you may try simple change:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Forum Contributor Jerry HKA's Avatar
    Join Date
    09-25-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    126

    Re: Breakdown 4 digit numbers into 2 digit-numbers

    Sorry, my bad... yes, it should have been 89,99....thanks, friend...God bless you...your help is really much appreciated.

+ 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. Extract 4 digit common numbers from 5 digit numbers
    By ameque in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2013, 01:09 AM
  2. Replace all one-digit number with two-digit numbers
    By sandykunaish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 09:56 AM
  3. [SOLVED] macro to extract 9 digit numbers as well as alpha numberic 9 digit numbers from txt file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2012, 10:15 AM
  4. To count numbers with 4 digit/5 digit with given Range.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2012, 08:49 AM
  5. [SOLVED] what is the minimum numbers set for 4 digit numbers from 0000 to 9
    By Ambika in forum Excel General
    Replies: 15
    Last Post: 01-27-2006, 06:55 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