Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I would like to know how to divide a cell into diagonally. I want to be able
to type the day of the week for one part, then have the line / and then the date. Any ideas? Monday/April 3 for example. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can't. I suggest changing the number format to accomplish this instead:
1. Select the desired cells 2. Select Format Cells Number tab 3. Select Custom from the Category list 4. Enter "dddd / mmmm d" in the Type window 5. Then just enter the date in the cells in any recognized date format. Never mind entering the day. Alternatively, forget the "/". Use the <Alt key to force a new line within the same cell: 1. Type in the day (e.g. "Sunday") 2. Hold down the <Alt key and press Enter 3. Type the date Regards, Greg "Cindy" wrote: I would like to know how to divide a cell into diagonally. I want to be able to type the day of the week for one part, then have the line / and then the date. Any ideas? Monday/April 3 for example. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Try: http://www.exceltip.com/st/Dividing_..._Title/45.html -- Cindy Wrote: I would like to know how to divide a cell into diagonally. I want to be able to type the day of the week for one part, then have the line / and then the date. Any ideas? Monday/April 3 for example. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=529498 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
I need to know if there is a way to divide a cell | Excel Discussion (Misc queries) |