LinkBack URL
About LinkBacks
In column number a1 I have set of date in the formate like dd-mm-yy-. But I am in need to change them only mm-yy format using formula so that it will not change even if we try to change it from format date option. Plese help
Regards,
Pramod
In column number a1 I have set of date in the formate like dd-mm-yy-. But I am in need to change them only mm-yy format using formula so that it will not change even if we try to change it from format date option. Plese help
Regards,
Pramod
Hi,
Why not change the format to mm-yy then ensure the cells are locked (they will be unless you've already unlocked them) and Protect the sheet to prevent changes.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks