Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formatting date
Hey,
is there any way to format this date 2005 so that it only shows the year number 5 thanks |
#2
|
|||
|
|||
I don't think you can do it in the cell. This might give you a solution but
in another cell: =RIGHT(TEXT(A1,"dd/mm/yyyy"),1) Regards Trevor "Torrance Pollard" wrote in message ... Hey, is there any way to format this date 2005 so that it only shows the year number 5 thanks |
#3
|
|||
|
|||
Right-click on the cell and select Format Cells. Click on the Number tab and
select Custom at the bottom of the list. Clear the Type: text box and enter yyyy. Click OK. "Torrance Pollard" wrote: Hey, is there any way to format this date 2005 so that it only shows the year number 5 thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date and time formatting | Excel Discussion (Misc queries) | |||
Incorrect Date formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
problem with formatting cell to date format | Excel Worksheet Functions | |||
Date Formatting | Excel Discussion (Misc queries) |