Wednesday, August 18, 2010

How to change comma format from thousands to indian format in digit in excel?

in excel i want to following format how to chane 12,34,56,789.00?





but in excel number only comes in thound fomat not comes in once, t hundreds, tenthousands, lakh, ten lakh format. cpmes come from above onbly how to change in formatg pl explain in detailHow to change comma format from thousands to indian format in digit in excel?
Right click the cell with the numbers and choose format cell%26gt;Numbers and make sure the check box for use 1000 separators is unchecked.

No comments:

Post a Comment