Posted to microsoft.public.excel.misc
|
|
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.
|