PC Review


Reply
Thread Tools Rate Thread

Excel Number format in Indian style (Lacs, Crores)

 
 
amitchand
Guest
Posts: n/a
 
      30th Aug 2004
HI,

Someone please help me in changing numbers in excel to Indian forma
..

say for ex.... 123456789 has to be displayed as 12,34,56,789 whic
basically is Rs. 12 crores 34 lacs 56 thousand and 789 rupees as pe
Indian currency system..

thanks

amit chan

--
Message posted from http://www.ExcelForum.com

 
Reply With Quote
 
 
 
 
Bernard Liengme
Guest
Posts: n/a
 
      30th Aug 2004
From a Google search here is a reply by David Richie to the same question in
January

If you have Excel 2002 or later look up bhattext in help.
Otherwise the following format might help you

[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00

(This format separates groups for India/Thailand, format valid for
positive numbers up to 99,99,99,999.99 or 999,999,999.99)
in Excel XP see function BhatText as in Thai Bhat currency.
=BAHTTEXT(A37) [Rupees, Rs., Paise, lakhs, crores] ==
an alternative may be to use Control Panel, Regional Settings, Numbers,
digit grouping.


see:
http://www.google.ca/groups?q=indian...phx.gbl&rnum=1

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address


"amitchand >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> HI,
>
> Someone please help me in changing numbers in excel to Indian format
> .
>
> say for ex.... 123456789 has to be displayed as 12,34,56,789 which
> basically is Rs. 12 crores 34 lacs 56 thousand and 789 rupees as per
> Indian currency system..
>
> thanks
>
> amit chand
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format in Indian style Bernard Liengme Microsoft Excel Discussion 1 6th Dec 2007 01:50 PM
Difference between big indian and little indian... Sir C4 Microsoft C# .NET 9 26th Oct 2006 06:45 PM
How to format a number in Indian style in Excel? =?Utf-8?B?VmljdG9yX2FsYg==?= Microsoft Excel Misc 2 21st Dec 2004 05:21 AM
Indian style Number Format Mahesh Kumar K Hegde Microsoft Excel Discussion 1 11th Dec 2004 04:15 PM
Import Indian Rupees as a number format in Excel =?Utf-8?B?QWRpdHlhIEtoYW5kZWthcg==?= Microsoft Excel Misc 2 6th Dec 2004 04:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:08 PM.