Quote:
Originally Posted by Stefi
You can do it in another cell (assume your original cell is A1) with
=TEXT(A1,"ddd") & " " & TEXT(A1,"dd/mm/yyyy")
and formatting the cell with wrapping.
Regards,
Stefi
€˛Joel€¯ ezt Ć*rta:
in my cell if the date detup as the following ddd/dd/mm/yyyy (tue/10/2006 now
that is to big for the cell so i end up having to make the colum wider. What
I want to achieve is the day at the t op of the cell and the date underneath
it like it is wrappped. It doesn't matter how tall i make the cell it makes
no difference
When I wrap the cell and reduce the width the # sign because it won't all
fit in the cell. can anyone please help
--
N/A
|
Hi - I'm using 2010 and tried this but I didn't get a line break between the day and date. Is there another something to put between to tell Excel to go to the next line within the cell?
Anne
Similar Threads
Threaded Mode
