+ Reply to Thread
Results 1 to 10 of 10

Require vba or formula for convert general format data in date format

  1. #1
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Require vba or formula for convert general format data in date format

    Hello All
    We have a database where in Colum H Date format data Enterd in General Format.. in following type
    CURRENT DATA
    Jul,2003
    Mar,2003
    Dec,2003
    Mar,2001
    Mar,2003

    We want above column H General Format Data in Date format following type in Colum I
    REQUIRED DATA
    Jul-03
    Mar-03
    Dec-03
    Mar-01
    Mar-03

    Currently when we replaCE ,20 in - then data convert in data format but show
    Jul-13
    3-Mar
    3-Dec
    1-Mar
    3-Mar



    FORUM EXPERT/GURU'S IF U PROVIDE ME A VBA OR FORMULA FOR MY ABOVE PROBLEM THEN I WILL REALLY THANKFULL TO YOU.

    THANKS IN ADVANCE

    SANTOSH
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Require vba or formula for convert general format data in date format

    Try this....

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Require vba or formula for convert general format data in date format

    Try this too...

    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Require vba or formula for convert general format data in date format

    formula
    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  5. #5
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Re: Require vba or formula for convert general format data in date format

    hello Sixthsense , Debraj & Humdingaling... first for thanks for response

    Actaully ur provided VBA or furmula convert data as per my requirement but when we try to filter in this data then excel 2007 data not filter with year wise + sign

    i think before mmmm-yy format we must 1 date of every month then we change to date format...

    pls if this possible then help me

    Thanks

  6. #6
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Require vba or formula for convert general format data in date format

    Then try this..

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Re: Require vba or formula for convert general format data in date format

    Thanks Roy,, this works perfectly what i want...
    Thank you so much to all of you..

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Require vba or formula for convert general format data in date format

    Quote Originally Posted by santosh226001 View Post
    i think before mmmm-yy format we must 1 date of every month then we change to date format...
    Just remove the Single Quote from the below line, since added it wantedly to make it as text....

    Please Login or Register  to view this content.

  9. #9
    Forum Contributor
    Join Date
    01-29-2012
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    434

    Re: Require vba or formula for convert general format data in date format

    Sixthsense ur this modified line work as per my requirement ... Thanks we also add reputation to you..

  10. #10
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Require vba or formula for convert general format data in date format

    Glad it helps you and thanks for the feedback and rep

+ 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] Macro to convert require date format
    By rvkadu1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-17-2013, 07:08 AM
  2. Convert from 'text' or 'general' to 'date' format
    By EmmieKae in forum Excel General
    Replies: 4
    Last Post: 07-11-2012, 02:30 PM
  3. [SOLVED] Convert a general format string to calendar date in Excel 2010 vba?
    By Kuriakos in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-18-2012, 11:44 AM
  4. Convert General Format to Date, Nested IF Function, If Yes then highlight row
    By woody04 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2012, 05:01 AM
  5. Convert general format to date
    By NickC in forum Excel General
    Replies: 3
    Last Post: 02-06-2006, 11:30 AM

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