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.
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.
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 <at>yahoo<dot>com
----
"Linda Hart" <Linda [email protected]> wrote in message
news:[email protected]...
> 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.
>
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 [email protected]> wrote in message
news:[email protected]...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks