+ Reply to Thread
Results 1 to 5 of 5

Help require to get output in Hindi numbers by formula used

  1. #1
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Help require to get output in Hindi numbers by formula used

    Dear friends,
    I’m using ‘Mangal’ Hindi font for entering the data but I’m not getting Hindi numbers in the output by formula. The output is in English numbers which I want in Hindi numbers. The marks are in Hindi numbers but the output is in English numbers.

    The remark in column ‘bz’ should be in English.

    Please help me to get the output in Hindi numbers.

    Thanking you.
    Attached Files Attached Files
    Sincerely,

    mso3

  2. #2
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Help require to get output in Hindi numbers by formula used

    For all cells that are not displaying "Devnagri" font; select them and then choose Custom Format [$-4000439]0. See attached image - Font.PNG
    HTH!

  3. #3
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help require to get output in Hindi numbers by formula used

    Hi Jewel,
    Thank you. The image file also shows English numbers.

    I want to know the meaning of the code you provided. What does it means? Which font?

    Please send me a excel file for my better understanding.

    The output in column 'a+b, average, average total, percentage' should be in hindi numbers. There are also some other columns which has a formula and I want the output in hindi numbers which I have not mentioned here because it is a sample file only.

    Thank you.

  4. #4
    Valued Forum Contributor
    Join Date
    12-02-2012
    Location
    Melbourne, VIC
    MS-Off Ver
    Excel 2016
    Posts
    750

    Re: Help require to get output in Hindi numbers by formula used

    Hi mso3,
    It is the same file you attached. I was just trying to show you how to convert the display from English to Devnagri. Typically, you will find that cells that have English font displayed will show "General" in the Number Format, and cells that display correctly as Devnagri will show "Custom" as their number format.

    The attached image shows how to set that custom format. (If I had gone ahead & clicked "OK" in the spreadsheet instead of taking that snapshot, those cells would then display Devnagri font).
    Hope this makes sense.

  5. #5
    Forum Contributor
    Join Date
    06-29-2014
    Location
    India
    MS-Off Ver
    2010 Windows 10 64 bits
    Posts
    1,269

    Re: Help require to get output in Hindi numbers by formula used

    Hi Jewel,
    Thank you for explanation. I followed it and solved the problem.

    Thank you and have a nice day.

+ 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 do write numbers in hindi?
    By Marwa Amin in forum Excel General
    Replies: 2
    Last Post: 01-07-2015, 04:05 AM
  2. [SOLVED] Help require to get a output in total column
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2014, 11:08 AM
  3. [SOLVED] Dividing number formula but require a minimum output?
    By dawondr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2013, 05:50 PM
  4. Is VBA possible on this output or does this require just a SUMIF formula?
    By geng in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2010, 03:24 AM
  5. [SOLVED] how do i get numbers in arabic not hindi?
    By marie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-19-2005, 01:06 PM

Tags for this Thread

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