Is it possible to create custom number format for Bengali numerals (১,২,৩,.......)
I found out it is possible for Hindi numerals using [$-4000439]0. Is there any similar way for Bengali? Please suggest me.
Is it possible to create custom number format for Bengali numerals (১,২,৩,.......)
I found out it is possible for Hindi numerals using [$-4000439]0. Is there any similar way for Bengali? Please suggest me.
Hi
Welcome to the board
Try:
[$-5000845]0
with
1234567890
I get
১২৩৪৫৬৭৮৯০
Thank you very much. I'm curious. How is this code generated? Does it have any relation with unicode or 'alt' codes of office?
You're welcome.
The general format of the international number format prefix code has 3 parts
NN CC LLLL
where NN is the code for the native numerals, CC the calendar you want to use and LLLL the LCID (Language Code Identifier) code
in your case you have
05 - Bengali numerals
00 - Gregorian calendar (I've no idea of what calendar you want but since you just wanted the numerals I used this one)
0845 - Bengali - Bangladesh (you can also use 0445: Bengali - India)
this whole prefix put together:
[$-05000845]
or
[$-05000445]
If want to know more look here:
https://help.libreoffice.org/Common/...ormat_Codes/nl
(there was for many years a nice ms page with all these International Number Format info but now is gone, or it moved I don't know where)
Can you please tell me how can i use [>99999]##\,##\,##0.00;[<-99999.99]-##\,##\,##0.00;##,##0.00 number format together with above format? This is to show thousand separator in lakh and crore instead of millions. Also I want to add currency symbol if possible. Thanks in advance. Really appreciate your help.
Hi
I don't know well your number notation. If you just add the international number format prefix code and the currency symbol to the format you posted does that work well?
[$-5000845][>99999]"৳ "##\,##\,##0.00;[<-99999.99]"৳ "-##\,##\,##0.00;"৳ "##,##0.00
If not, post some examples so that we can test.
Last edited by lecxe; 05-09-2017 at 07:30 AM.
This works like a charm. Thank you so much. I got ৳ ৪,২২,৪১৫.০০ from 422415
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks