hundreds separator
Instead of thousands separator, I want use hundres separator example 1,00,000
could you help me |
hundreds separator
[=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) "Viraj Nayaka" <Viraj wrote in message ... Instead of thousands separator, I want use hundres separator example 1,00,000 could you help me |
hundreds separator
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 |
All times are GMT +1. The time now is 04:52 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com