Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Convert date in excel

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-05-07 : 11:29:16
D writes "How do convert a column of dates in an excel spreadsheet to display from 9/2/2002 to show as 09/02/2002"

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-05-07 : 12:57:03
1.) Select the cells that you want to format.
2.) Click on ormat.
3.) Click on cells
4.) Click on Custom
5.) under type - type dd/mm/yyyy

Click on OK]


Duane.
Go to Top of Page
   

- Advertisement -