Wrapping a date in excel
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 |
Wrapping a date in excel
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 |
Wrapping a date in excel
Thank you stefi
So once I have done that for a1 I can dragg it over the next 365 cells to get a yeaar? -- N/A "Stefi" wrote: 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 |
Wrapping a date in excel
Of course!
Stefi €˛Joel€¯ ezt Ć*rta: Thank you stefi So once I have done that for a1 I can dragg it over the next 365 cells to get a yeaar? -- N/A "Stefi" wrote: 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 |
Quote:
Anne |
All times are GMT +1. The time now is 02:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com