 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005Separating Dates into Diff Columns
How do you separate a date into seperate columns?? i.e. December 15, 1978 from one cell into three different cells, one for the month, one fo the date, and one for the year. thanks in advance >How do you separate a date into seperate columns?? >i.e. December 15, 1978 >from one cell into three different cells, one for the month, one for >the date, and one for the year. > >thanks in advance. Here's one way: A1: December 15, 1978 (as an Excel date) B1: =TEXT(A1,"yyyy") C1: =TEXT(A1,"mmmm") D1: =TEXT(A1,"d") --ron |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.