Search : in
By :

Convert date into month name

Last answer on Aug 21, 2009 9:24:21 am BST danny, on Jul 31, 2009 11:24:14 am BST 
 Report this message to moderators

Hello,

suppose date has mention 1/1/09 and no month name then how to get the month name

Configuration: Windows XP Internet Explorer 7.0

Best answers for « convert date into month name » in :
Converting Date into words Show
Import web data into Excel Show
How to convert Excel into PDF? Show How to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Converting VHS into a digital format ShowConverting VHS into digital format Digititalize your VHS tapes without capture card You have some video tapes that are precious to you and don't want to lose them.Then better sotre them in a Digital format. In this tip, we...
Power supply is not working properly ShowPower supply is not working properly Intro Electrical Verification Electrical protection Checking the power block Intro The power supply converts electrivity into low DC voltage to be used by yourcomputer. If your computer reboot...
Download DBxtra ShowDBxtra is an application designed to convert data into valuable information. It can create queries with unlimited filters and sort orders. Advantage It deploys report without any difficulties. It needs no requirements system. You do not need to...
Download Free Word/Doc Txt to Image Jpg/Jpeg Bmp Tiff Png ShowIt is usually the images that we insert into Word, Excel or PowerPoint documents. This time, it is the opposite, because we are going to convert these documents to image formats. All to Jpg / JPEG Image Bmp Tiff Png Converter is a powerful tool which...
Download Logicity - Crystal Reports Viewer Show
Uuencode/Uudecode ShowUuencoding UUencode encoding (a contraction of Unix-to-Unix encode) is an algorithm for converting 8-bit binary data into a 7-bit format. Uuencoding was originally created for sending binary files using the email protocol uucp. The uucp system...
BinHex encoding ShowBinHex encoding BinHex encoding (a contraction of binary-to-hexadecimal) is a proprietary algorithm owned by Apple for converting 8-bit binary data into a 7-bit format. BinHex encoding, designed for Macintosh systems, is used to preserve file...
Graphics cards - Video cards Show2D Accelerator Cards A graphics card, sometimes called a graphics adapter, video card or graphics accelerator, is a computer component which converts digital data into a graphical form which can be displayed on a monitor. The initial role of a...
Ask your question Reply

1

Trowa, on Jul 31, 2009 11:54:57 am BST

Danny, did you even try Venkat's solution.

I tried it and it works like a charm, guess you would like to read it again:

Suppose you have 1/1/09 in cell A1,
Then use cell B1 to input this formula: =TEXT(A1,"mmm") .
If you want the full monthname instead of 3 letters add another m,
like this =TEXT(A1,"mmmm") .

Hope it's clear now.

Best regards,
Trowa

   
Reply to Trowa

2

 TIPO, on Aug 21, 2009 9:24:21 am BST

Thanks for your nice tips

   
Reply to TIPO
Ask your question Reply
They need your help