如何在PHP中计算Excel中的实际值，如1.30389E + 15？

Question

I see there are values displayed in Excel like - 1.30389E+15 Its original value is 1303890710980110

Does anyone have idea about how to convert this back to original value in PHP?

I tried searching it, but never came out with success. I don't know at this point of time what exactly this is called so that I can search the exact term.

Answer 1

You can use the number_format to achieve the conversion.

echo number_format(1.30389E+15);

Output: 1,303,890,000,000,000

The output posted above doesn't match your original value 1303890710980110 but that's how you would convert scientific notation.

In order to get the original value you mentioned, the notation would look like this 1.30389071098011E+15.

To check simply run: echo number_format(1.30389071098011E+15);

This would give you 1,303,890,710,980,110, the original value.