Brian

Hi By going to >> Fomat Cells >> set Decimal places to 0 and tick commas Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example for attachment below is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas Test file below Plus im just using XLSX to html table...

Hi By going to >> Fomat Cells >> set Decimal places to 0 and tick commas Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas Test file below Plus im just using XLSX to html table example <?php if ( $xlsx...

Hi By going to >> Fomat Cells >> set Decimal places to 0 and tick commas Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas Test file below Plus im just using XLSX to html table example if ( $xlsx =...

Hi By going to >> Fomat Cells >> set Decimal places to 0 and tick commas Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas Test file below Plus im just using XLSX to html table

Hi By going to >> Fomat Cells >> set Decimal places to 0 and tick commas Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas Test file below

Hi By going to >> Fomat Cells >> set Decimal places to 0 and tick commas Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas Is it meant to do this? As the excell page has no decimals. Only seems to do it to formulas Test file below

Hi By going to >> Fomat Cells >> set Decimal places to 0 Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell(our example is 17,862) In excell we see 24,810 for our formula answer, in webpage we see 24,810.318 Is it meant to do this? As the excell page has no decimals. Only seems to do it to formulas Test file below

Hi By going to >> Fomat Cells >> set Decimal places to 0 Then using this formula in a cell with data we get decimals =A1(1+Sheet2!A1:A1) or =A1(1+38.90%) add any number to A1 cell In excell we see 24,810, in webpage we see 24,810.318 Is it meant to do this? As the excell page has no decimals. Only seems to do it to formulas Test file below