I need to display both the Day in text and the date in serial numbers. How do I do that?
B Belinda Jun 19, 2006 #1 I need to display both the Day in text and the date in serial numbers. How do I do that?
A aidan.heritage Jun 19, 2006 #2 I hope you don't mean serial numbers (!) - format, cells set the format to custom as dddd mmm dd yyyy
I hope you don't mean serial numbers (!) - format, cells set the format to custom as dddd mmm dd yyyy
R Rob Hick Jun 19, 2006 #3 or use the same code in the text function, e.g: TEXT(A1,"Dddd Mmm dd yyyy")
C CLR Jun 19, 2006 #4 Right-click on the cell with the date, then FormatCells > NumberTab > Custom and in the Type: window, dddd m/d/yyyy > ok Click to expand... Vaya con Dios, Chuck, CABGx3
Right-click on the cell with the date, then FormatCells > NumberTab > Custom and in the Type: window, dddd m/d/yyyy > ok Click to expand... Vaya con Dios, Chuck, CABGx3
