+ Reply to Thread
Results 1 to 4 of 4

Convert text month to number month ?

  1. #1
    Forum Contributor
    Join Date
    02-20-2023
    Location
    thai
    MS-Off Ver
    2016
    Posts
    106

    Convert text month to number month ?

    Hello.

    I have value text month = Jan
    I want convert to number month format 01
    Code as below.


    Please Login or Register  to view this content.
    but now output show 1.
    How to edit it?

    Thank you.

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,914

    Re: Convert text month to number month ?

    Try this

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    02-25-2023
    Location
    Tindivanam
    MS-Off Ver
    365
    Posts
    34

    Re: Convert text month to number month ?

    How do I run this? Where will the result be displayed?

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,960

    Re: Convert text month to number month ?

    This is not your thread.

    Administrative Note:

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #1 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to convert month and year to the number of the month
    By parsenov in forum Excel General
    Replies: 3
    Last Post: 12-10-2019, 04:57 PM
  2. text number convert to month
    By leakhna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-21-2019, 11:32 PM
  3. how to convert the month in a date to the text word for that month
    By sthshrmags in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2014, 03:15 PM
  4. [SOLVED] Excel 2007 : How to convert month number to month name
    By FDibbins in forum Excel General
    Replies: 14
    Last Post: 04-08-2014, 12:42 AM
  5. [SOLVED] Function or formula to convert "text" month to number of month?
    By Steve Vincent in forum Excel General
    Replies: 1
    Last Post: 02-06-2006, 05:35 PM
  6. [SOLVED] RE: Function or formula to convert "text" month to number of month?
    By Kevin Vaughn in forum Excel General
    Replies: 0
    Last Post: 02-04-2006, 12:50 PM
  7. Replies: 1
    Last Post: 02-04-2006, 12:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1