Hi
In a cell formatted as date (month-year) is it possible to:
i.e enter "12":
FORMULA BAR shows: Current Year-December-01 (since day not specified).
The CELL shows: Dec-Current year (2 digit is fine).
Thanks
Hi
In a cell formatted as date (month-year) is it possible to:
i.e enter "12":
FORMULA BAR shows: Current Year-December-01 (since day not specified).
The CELL shows: Dec-Current year (2 digit is fine).
Thanks
Last edited by drgkt; 01-05-2017 at 06:26 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks