| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show the day and date in excel in the same cell
I need to show the day and the date in the same cell
tue 27/02/06 wed 28/02/06 can anyone help please |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show the day and date in excel in the same cell
Assuming your ariginal date is in cell A1, paste this in cell A3 and copy down as far as needed. =TEXT($A$1+ROW()-2,"ddd, m/d/yyyy") Matt -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310 View this thread: http://www.excelforum.com/showthread...hreadid=515742 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I show the day and date in excel in the same cell
sharkey Wrote: I need to show the day and the date in the same cell tue 27/02/06 wed 28/02/06 can anyone help please assuming you have dates in the cells just use Cell Format Number custom and type this in the box ddd dd/mm/yy -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=515742 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
