You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Wrap Full Date in a Cell

Is it possible to create a custom format to achieve the date format in A3 (wrap the date)? Currently, I input the day, option/return to wrap the next line and enter month, day, year. I would like to enter 9/4/21 and have the date automatically wrap shown in A3.

Posted on Sep 4, 2021 7:08 PM

Reply
Question marked as Top-ranking reply

Posted on Sep 5, 2021 12:15 AM

Yes, you can. Create a custom format. Use Option Return to put the carriage return after the day name. I'd show a screenshot but the text box for the format only shows one line, not the entire thing, so it would be more confusing than helpful. Click to create a custom format, make it a date&time format, drag the day name to the front of it, put the cursor to the right of the day name and hit Option Return to add the carriage return.


2 replies
Question marked as Top-ranking reply

Sep 5, 2021 12:15 AM in response to Rocket-JoJo

Yes, you can. Create a custom format. Use Option Return to put the carriage return after the day name. I'd show a screenshot but the text box for the format only shows one line, not the entire thing, so it would be more confusing than helpful. Click to create a custom format, make it a date&time format, drag the day name to the front of it, put the cursor to the right of the day name and hit Option Return to add the carriage return.


Wrap Full Date in a Cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.