Column A in the attached has some dates. It shows Dates in mm-yy format . But if I double click on those cells it shows the date in 11/01/2011 format. Is there any way I can show the date in mm-yy format even if I double click on any cells.
Simply, I want the data to be in the format as shown in column B. Help me on this
The only way would be to disable the "Allow editing directly in cells"
HTH
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks