Im using PHPexcel Library for exporting data in my SQL Server Database
Is there a way to style a cell with "Comma Style"
, e.g., "1000000" as "1,000,000"
?
Im using PHPexcel Library for exporting data in my SQL Server Database
Is there a way to style a cell with "Comma Style"
, e.g., "1000000" as "1,000,000"
?
Yes, using the number format function
<?php
echo number_format(1000000);//will output 1,000,000
Do read the full docs though, number_format() is far more powerful than that.