Hundred Seperator in Excel
 

Hi Everyone,

Well I came accross a question, to beign with is that
Excel uses Thousands a seperator giving figures in millions and Billions,
However I want to have figures in Thousands and Lakhs and crore..
EX: There is a figure 123456789 that will appear in excel as 123,456,789....
Right...
But i want to have it as 12,34,56,789...... So is it possible.....

Thanks

K****ij

Hundred Seperator in Excel
 

In MS Excel , (comma) denotes thousands separator. Try the below add-in to
convert to Indian format..

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

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


"K****ij" wrote:

Hi Everyone,

Well I came accross a question, to beign with is that
Excel uses Thousands a seperator giving figures in millions and Billions,
However I want to have figures in Thousands and Lakhs and crore..
EX: There is a figure 123456789 that will appear in excel as 123,456,789....
Right...
But i want to have it as 12,34,56,789...... So is it possible.....

Thanks

K****ij

Hundred Seperator in Excel
 

Hi Jacob... Really thanks for the same......

I appreciate your response.....

Thanks

"Jacob Skaria" wrote:

In MS Excel , (comma) denotes thousands separator. Try the below add-in to
convert to Indian format..

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

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


"K****ij" wrote:

Hi Everyone,

Well I came accross a question, to beign with is that
Excel uses Thousands a seperator giving figures in millions and Billions,
However I want to have figures in Thousands and Lakhs and crore..
EX: There is a figure 123456789 that will appear in excel as 123,456,789....
Right...
But i want to have it as 12,34,56,789...... So is it possible.....

Thanks

K****ij