 |
 | 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 / Worksheet Functions / March 2007Date to Text
I would like to change a date into text. Cell A1 - 03/14/2007 I would like to change that value to March 2007, and I don't mean by changing the format of the cell. I want the value to be March 2007. Hi I think you'll need a helper column with: =TEXT(A1,"mmmm yyyy") copied down, and then copy and paste values back into your original column. There would be VBA solutions in addition. Hope this helps! Richard > I would like to change a date into text. > > Cell A1 - 03/14/2007 > > I would like to change that value to March 2007, and I don't mean by > changing the format of the cell. I want the value to be March 2007. |
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.