I need to wrap 1 sep 11 so the 11 is below the 1 Sep. I keep getting #####
I need to wrap 1 sep 11 so the 11 is below the 1 Sep. I keep getting #####
Hi and welcome top the forum
Using a regular date, you cant, because a date is actually a 5-digit number (today is 41554). So unless you are using text - or convert it to text, you cannot break it apart.
maybe =TEXT(E15,"d mmm")&CHAR(10)&" "&TEXT(E15,"yy")
format as wrapped text
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Select the cell in question, custom format type: dd mmm
then key alt+0010 using the numeric keypad, then yy. The Excel internal numeric value is unchanged for calcs.
Ben Van Johnson
welcome to the forum. an alternative way using protonLeah's method, you could press CTRL + J instead of alt+0010.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks