+ Reply to Thread
Results 1 to 3 of 3

Formula to truncate

  1. 01-21-2018, 10:39 AM #1
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to truncate

    Hello:

    I have cell B8 = 9/30/2017 Balance

    I need formula in cell B4 to give 09-2017

    Please let me know if you have any questions.
    Thanks.

    R
    Reply With QuoteRegister To Reply
  2. 01-21-2018, 10:44 AM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,551

    Re: Formula to truncate

    Try this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  3. 01-21-2018, 10:51 AM #3
    rizmomin
    rizmomin is offline
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Formula to truncate

    Hello Mike:

    Thanks a lot, works

    Riz
    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. [SOLVED] Formula to truncate
    By rizmomin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2017, 01:57 PM
  2. [SOLVED] formula to truncate
    By rizmomin in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-01-2017, 08:56 AM
  3. [SOLVED] Formula to Truncate data
    By rizmomin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-12-2017, 02:03 PM
  4. [SOLVED] Formula to Truncate and Transpose
    By rizmomin in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-24-2017, 01:12 AM
  5. Formula to truncate
    By rizmomin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2016, 01:47 AM
  6. [SOLVED] Truncate At Specific Character Formula - And More. - Help Needed.
    By TheProffesional in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-07-2013, 04:11 PM
  7. [SOLVED] Formula Needed To Truncate Postcodes
    By Dom2066 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-27-2012, 03:03 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