Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get my date to look like this in Excel (Monday June 19,.
I need to display both the Day in text and the date in serial numbers. How do
I do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get my date to look like this in Excel (Monday June 19,.
I hope you don't mean serial numbers (!) - format, cells
set the format to custom as dddd mmm dd yyyy Belinda wrote: I need to display both the Day in text and the date in serial numbers. How do I do that? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get my date to look like this in Excel (Monday June 19,.
or use the same code in the text function, e.g:
TEXT(A1,"Dddd Mmm dd yyyy") wrote: I hope you don't mean serial numbers (!) - format, cells set the format to custom as dddd mmm dd yyyy Belinda wrote: I need to display both the Day in text and the date in serial numbers. How do I do that? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get my date to look like this in Excel (Monday June 19,.
Right-click on the cell with the date, then FormatCells NumberTab Custom
and in the Type: window, dddd m/d/yyyy ok Vaya con Dios, Chuck, CABGx3 "Belinda" wrote: I need to display both the Day in text and the date in serial numbers. How do I do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel date format trouble | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
excel array formula | Excel Worksheet Functions | |||
Excel file modification date | Excel Discussion (Misc queries) | |||
Excel formula with date constraints | Excel Discussion (Misc queries) |