Results 1 to 10 of 12

Thread: Showing Month Abbreviation With Using 2 Characters

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Jul 2013
    Posts
    3
    Rep Power
    0

    Showing Month Abbreviation With Using 2 Characters

    I work in a factory where we use 2 letter month expiry abbreviations. I'm trying to get Excel to show it the same way, but it's limited to Jan, 01, January, etc.
    Is there a way I can get it to show JA instead?
    We have a spreadsheet that autopopulates a 6 month and 9 month expiration from the current date.
    IE 01/12/2013 turns into =M1800+180 (2014/May/30) and =M1800+270 (2014/Aug/28)
    So I can't just write a choose/if formula. I'm not sure there's any way of doing this, any help would be appreciated.
    (I've attached a copy of an example as well)
    Attached Files Attached Files

Similar Threads

  1. Custom Charts in Excel :: Comparison RAG Chart Showing Tolerance Limits
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-13-2013, 09:40 PM
  2. Find Mismatch Characters:
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 06-06-2013, 07:53 PM
  3. Extract Certain Characters From A Text String
    By bobkap in forum Excel Help
    Replies: 5
    Last Post: 05-24-2013, 06:25 AM
  4. Excel Chart Showing Values on Angle: Nightingale Chart
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 10-17-2012, 06:39 PM
  5. Remove Special Characters :
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 3
    Last Post: 03-06-2012, 09:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •