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.

Hi there,

If you want to stick with Access you can use a calculated value in your data table, viz.:

Please Login or Register  to view this content.

If you want to move your data to Excel you can use the following formula (where the value you want to convert is located in Cell A2):

Please Login or Register  to view this content.

The attached database and workbook shows the results of the above.


Hope this helps.

Regards,

Greg M

Thank you Greg M! that works

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Best regards,

Greg M