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.