Report

Inserting day of week along with date [Closed]

Ask a question martin firth - Last answered on Nov 14, 2017 at 07:36 AM by Chapel Chick
Hello,

I am currently working on a spreadsheet and trying to set the cell format so that it displays the day of te week alongside the date eg Wed 12/11/08. Is this possible? If so how?
Thanks for your ooking into this nad in anticipation of someone providing me with a solution..
martin
Helpful
+43
plus moins
Right-click on the cell, choose "Format cells", go to "Custom" & type "ddd dd/mm/yy" in the "Type" box.
Pete- Feb 1, 2009 at 10:24 AM
That is great, but I would like to know how to stick a carriage return in after the day? i.e.

Sunday
01/02/2009


Wrap text, then squash the column results in ########################

Pete
Needo- Oct 4, 2011 at 06:46 PM
great !!!
Chapel Chick- Nov 14, 2017 at 07:36 AM
It worked! Thank you. Is there a way to get the text to wrap so that the day is on top of the date? wrap text is checked but only a single line of text is visible.
Reply

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!