+ Reply to Thread
Results 1 to 2 of 2

English birthdates. I want to change the date in Devanagari font

  1. #1
    Registered User
    Join Date
    12-27-2016
    Location
    amravati, maharashtra
    MS-Off Ver
    10 and 13
    Posts
    5

    English birthdates. I want to change the date in Devanagari font

    Hi,
    The date to word function works fine for English birthdates. I want to change the date in Devanagari font. VBE didn’t accept the Marathi font. If I type Marathi font in VBE then it shows meaningless characters.

    Please do suggest me a code to convert the Marathi date in words. It’s very urgent for my project because my work is stopped.

    Any help will be highly appreciated.

    Waiting to receive a solution at the earliest.

    Thanking you in anticipation.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: English birthdates. I want to change the date in Devanagari font

    In the attached, you will find a sheet called Regional Font. Currently I have listed all the dates, months and years in Hindi font, change them to Marathi or your regional language then you can use the function DateInRegionalFont() as shown on the sheet1.
    If you change the name of the sheet Regional Font to something else, please remember to change it in the code also in the following line....
    Set ws = Sheets("Regional Font")
    You may hide this sheet if required.

    See if this is something you can work with.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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. How to convert English font date in to Marathi Devnagri font
    By milind namdar in forum Excel General
    Replies: 2
    Last Post: 07-25-2016, 08:52 AM
  2. [SOLVED] Not getting date in devanagari font
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2015, 07:25 AM
  3. Help require to change the format of column D & J to devanagari font
    By mso3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-29-2014, 09:08 PM
  4. [SOLVED] Help require to convert devanagari date in devanagari words
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-03-2014, 12:30 PM
  5. Unable to get date in devanagari font
    By mso3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2014, 01:17 AM
  6. Change date format from US to English (Australian)
    By altona in forum Excel General
    Replies: 3
    Last Post: 05-04-2006, 10:15 PM
  7. [SOLVED] I cannot change the date format to English canada
    By DStanfield in forum Excel General
    Replies: 2
    Last Post: 09-28-2005, 02:05 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