Formatting Question

[Metalteck]

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

[CyberTaz]

Select the cells, go to Format>Cells, 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?