Hi Senapati

The best I can offer is; if you are looking for Indian format; say we have a
figure 12345678 to be displayed as 12,345,678.00 then check out the below
link for an add-in

http://www.dq.winsila.com/tips-trick...and-words.html

If this post helps click Yes
---------------
Jacob Skaria


"Senapati" wrote:

I want to that once a number is entered in a cell it would be converted to a
form that has a comma inserted after every two digits from right to left.
example - 1 as 1; 123 as 1,23; 2345 as 23,45 and so on
Can anyone would help me please. Thanks