 |
 | 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 / July 2007Convert day, month, year, and time to just year
Hello, what formula can I use to convert day, month, year, and time values to just a year For example, what formula can I use to convert 4/16/2002 12:59pm to simply 2002 or 1/1/2002. bmac =YEAR(A1) or just format the cell as YYYY to se ethe year but retain the value  SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Hello, what formula can I use to convert day, month, year, and time values > to just a year [quoted text clipped - 3 lines] > > bmac Thasnks for responding ... I still must be doing something wrong ... In E2 I have the date 6/20/2001 12:25pm and then enter in H2 ... =YEAR(E2) and I get the value 6/23/1905. Any ideas? > =YEAR(A1) > [quoted text clipped - 7 lines] >> >> bmac Format it as General (or number)--just not a date. > Thasnks for responding ... I still must be doing something wrong ... > [quoted text clipped - 22 lines] > >> > >> bmac SignatureDave Peterson Thanks very much! > Format it as General (or number)--just not a date. > [quoted text clipped - 25 lines] >> >> >> >> bmac I'm just your patsy aren't I? I lead with a half-volley, and you smash the winner <g> Do you play tennis? SignatureHTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Format it as General (or number)--just not a date. > [quoted text clipped - 25 lines] >> >> >> >> bmac Maybe you can lead the league in assists! > I'm just your patsy aren't I? I lead with a half-volley, and you smash the > winner <g> [quoted text clipped - 41 lines] > > > > Dave Peterson SignatureDave Peterson |
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.