Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three digit commas separator
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three digit commas separator
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Three digit commas separator
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. |
#4
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Use 100 separator inspite of 1000 separator in excel | Excel Worksheet Functions | |||
Use commas as decimal separator | Excel Discussion (Misc queries) | |||
Excel 2007-digit separator ',' for numbers/currency exceeding 999, | Excel Discussion (Misc queries) | |||
Removing Digit Separator | Excel Worksheet Functions | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) |