I have a field in my spreadsheet that is typed in as 6/29/5. How can I change this to 6/29/2005?
M Metalteck Jul 15, 2005 #1 I have a field in my spreadsheet that is typed in as 6/29/5. How can I change this to 6/29/2005?
C CyberTaz Jul 15, 2005 #2 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 |:>)
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 |:>)
