Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b.
I want to create an excel column that will show yr/mo/day all in numbers so I
can easily sort. Can this be done? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel cell showing Yr/Mo/Day in numbers only (09/11/06) can it b.
--You can custom format to yyyy/mm/dd (Right clickFormatCellsNumberselect
Date or select Custom and enter yyyy/mm/dd) --If you enter the dates in excel date format.you can do the sorting in asc or desc as excel stores the dates as numbers Just check out the below link by Chip http://www.cpearson.com/excel/datetime.htm If this post helps click Yes --------------- Jacob Skaria "Bongo" wrote: I want to create an excel column that will show yr/mo/day all in numbers so I can easily sort. Can this be done? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i stop excel from showing numbers as dates | Excel Discussion (Misc queries) | |||
excel graph is only showing numbers not words-how do I change? | Charts and Charting in Excel | |||
Excel is showing numbers as headers for both rows and columns?? | Setting up and Configuration of Excel | |||
Why is one cell showing numbers in blue and how do I change that? | Excel Discussion (Misc queries) | |||
Adding numbers in one cell and showing total in seperate cell | Excel Discussion (Misc queries) |