+ Reply to Thread
Results 1 to 4 of 4

Formula to reverse number order

  1. 03-24-2016, 10:44 AM #1
    amandakayelitte
    amandakayelitte is offline
    Registered User
    Join Date
    02-02-2015
    Location
    evansville, in
    MS-Off Ver
    2010
    Posts
    26

    Formula to reverse number order

    Is there a formula I can write that will reverse the number order of the following? I want to change 02-25-6000 to 6000-25-02. Any help would be appreciated. Thanks!
    Reply With QuoteRegister To Reply
  2. 03-24-2016, 10:47 AM #2
    Jack7774
    Jack7774 is offline
    Forum Contributor Jack7774's Avatar
    Join Date
    08-31-2012
    Location
    Georgia, US
    MS-Off Ver
    Excel 2010
    Posts
    576

    Re: Formula to reverse number order

    Give that cell H8 would have the data you would want to reverse and that the money and day are always two digits. 

    Please Login or Register  to view this content.
    Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
    Reply With QuoteRegister To Reply
  3. 03-24-2016, 10:52 AM #3
    JohnTopley
    JohnTopley is offline
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,206

    Re: Formula to reverse number order

    With format of AA-BB-CCCC

    =RIGHT(A1,4) & "-" & MID(A1,4,2) & "-" & LEFT(A1,2)
    Reply With QuoteRegister To Reply
  4. 03-24-2016, 11:02 AM #4
    amandakayelitte
    amandakayelitte is offline
    Registered User
    Join Date
    02-02-2015
    Location
    evansville, in
    MS-Off Ver
    2010
    Posts
    26

    Re: Formula to reverse number order

    Thanks so much, this helped!
    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. Formula for getting data from week number (reverse WEEKNUM)
    By grime in forum Excel General
    Replies: 5
    Last Post: 12-05-2017, 07:39 PM
  2. [SOLVED] reverse the order of words with formula
    By Aquamore in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-15-2014, 10:22 PM
  3. [SOLVED] Reverse order using formula
    By ganeshkumar in forum Excel General
    Replies: 6
    Last Post: 11-26-2013, 02:38 PM
  4. [SOLVED] reverse order
    By anilg0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 04-18-2013, 07:53 AM
  5. [SOLVED] Vlookup formula in a reverse order loop
    By JMaug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-01-2012, 10:48 PM
  6. [SOLVED] Combining letters and the last three digits of a number in reverse order
    By Closet Coder in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-21-2012, 08:40 AM
  7. [SOLVED] Macro to Reverse Order of Columns but Dependent on Number of Data Rows
    By francois28 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 06:34 PM
  8. [SOLVED] reverse order
    By Lamb Chop in forum Excel General
    Replies: 4
    Last Post: 06-20-2006, 10:40 AM

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