Results 1 to 5 of 5

to show month and year only

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    San Diego, USA
    MS-Off Ver
    Excel 2019
    Posts
    871

    to show month and year only

    i have a table in the column , i want it to show month and year only
    like this: 06/24
    06 being the month, and 24 being the year
    but it shows as 62/4 or 624
    and for october, november and december ..when we enter data, we enter it with 4 digits number, but for the rest of the month, we just enter 3 digits ..being only month and year
    please see attachment, thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to show hours base on month column and phase wise month and year
    By mtakawane in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-28-2022, 09:12 AM
  2. [SOLVED] cbbox that will dynamically show current year month and year
    By pb21uk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-19-2022, 05:32 AM
  3. [SOLVED] Drop Down list showing current month & year and formula to show Prev Year
    By Howardc1001 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-30-2020, 11:54 PM
  4. [SOLVED] display cell to show only Month/year to do sumif calc if today()= any day of month
    By fireguy7 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-12-2013, 06:55 PM
  5. [SOLVED] How to show yesterdays date without month year.
    By DKerr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-18-2012, 10:17 AM
  6. Show dates as month and year
    By Mary F in forum Excel General
    Replies: 2
    Last Post: 06-21-2012, 11:26 PM
  7. [SOLVED] HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS?
    By noles fan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2005, 01:05 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