PC Review


Reply
Thread Tools Rate Thread

Character Month from Date Data type

 
 
=?Utf-8?B?VmlrYXMgS2FsZQ==?=
Guest
Posts: n/a
 
      6th Nov 2007
If I am having a date data type column in a worksheet and I want the
Character Month of it in second column, How can I get it?
 
Reply With Quote
 
 
 
 
=?Utf-8?B?U3RlZmk=?=
Guest
Posts: n/a
 
      6th Nov 2007
=TEXT(A1,"mmmm")
Regards,
Stefi


„Vikas Kale” ezt *rta:

> If I am having a date data type column in a worksheet and I want the
> Character Month of it in second column, How can I get it?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form Field of Date Type Not Keeping Month Portion Of Date Ronald R. Dodge, Jr. Microsoft Word Document Management 1 20th Oct 2008 11:46 AM
Pull Specific Data by Previous Month's Date (Date Entered via prom Vylent Fyre Microsoft Access Queries 1 25th Jan 2008 06:13 PM
Sort month/date/year data using month and date only =?Utf-8?B?U01XODIw?= Microsoft Excel Misc 6 22nd Jun 2006 05:14 PM
using date function, month shows as January when i type (12) =?Utf-8?B?aHNhcw==?= Microsoft Excel Misc 3 17th Jun 2005 07:15 PM
Converting Month/Date/Year data & sorting by month/date only =?Utf-8?B?Uy4gV2FzaGluZ3Rvbg==?= Microsoft Excel Worksheet Functions 4 26th Apr 2004 05:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:53 PM.