Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change yyyy date to yy
Can I change the date "short" format (yyyy) to "shorter" format (yy)?
e.g. 7/7/2005 to 7/7/05 This would be for a range of dates in an existing column, as well as for new dates to be added. |
#2
|
|||
|
|||
Select the col of dates
Click Format Cells Number tab Under category, choose Custom In Type: box, input: m/d/yy Click OK -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "Linda Hart" <Linda wrote in message ... Can I change the date "short" format (yyyy) to "shorter" format (yy)? e.g. 7/7/2005 to 7/7/05 This would be for a range of dates in an existing column, as well as for new dates to be added. |
#3
|
|||
|
|||
Select the cells you want to reformat; then go to Format-Cells, and click on
the Number tab. Select Custom, and in the small box to the right type the format you want: m/d/yy. Hit Enter and that should do it. If you want to change the computer's default date setting, go to Control Panel, Regional and Language Options, and make changes there. "Linda Hart" <Linda wrote in message ... Can I change the date "short" format (yyyy) to "shorter" format (yy)? e.g. 7/7/2005 to 7/7/05 This would be for a range of dates in an existing column, as well as for new dates to be added. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change date format? | Excel Discussion (Misc queries) | |||
How do I change the default date format in an Excel Footer | Setting up and Configuration of Excel | |||
Change cell according to date | Excel Worksheet Functions | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
How do you change the date to a Number | Excel Discussion (Misc queries) |