unanswered Convert date to text

  • wcomp01@gmail.com
  • wcomp01@gmail.com's Avatar Topic Author
  • Offline
More
1 month 3 weeks ago #2288 by wcomp01@gmail.com
Convert date to text was created by wcomp01@gmail.com
Some time when you paste the string 2-1, Excel converts it to date format and appends a year, and it becomes Feb-1. Is there a way in Kutools for excel that converts the cell content and format to text only.
Currently I create an adjacent column add the function
=TEXT(A1, "m-d")

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun