Instead of thousands separator, I want use hundres separator example 1,00,000 could you help me
V Viraj Nayaka Sep 6, 2006 #1 Instead of thousands separator, I want use hundres separator example 1,00,000 could you help me
B Bob Phillips Sep 6, 2006 #2 [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
[>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 will format say 1234567890 as 123,45,67,890.00 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
M MartinW Sep 6, 2006 #3 Hi Viraj, Custom number format as 0","00","000 will display as per your example. Play with other variations if you need something slightly different. HTH Martin
Hi Viraj, Custom number format as 0","00","000 will display as per your example. Play with other variations if you need something slightly different. HTH Martin
