View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Three digit commas separator

Hi Yeshwant

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


"YESHWANT JOSHI" wrote:

hi Gord,

can u tell me how to format a cell for figure 12345678 to be shown as
1,23,45,678.00 i. e. Indian style of numbering

"Gord Dibben" wrote:

What should 1234 look like

What should 12345 look like

And 123456

And 12345678

Thousands separator is set under FormatCellsNumberNumber

Enable would display 1,234 12,345 123,456 12,345,678


Gord Dibben MS Excel MVP

On Tue, 11 Aug 2009 11:49:01 -0700, jrhl
wrote:

How can I setup Excel to show a comma every three digits like it used to be
in 2003? Right now it only shows the first comma after three digits.