Select the cells, go to FormatCells, click Date in the list of categories &
pick what you want from the choices offered. You should find what you want
there.

HTH |:)

"Metalteck" wrote:

I have a field in my spreadsheet that is typed in as 6/29/5. How can I change
this to 6/29/2005?