I have created a php file, in that I am copying a html table to an excel sheet.
While copying the numbers are turned in to the exponent form (like 2.00e+14).

If i manually chage the cell format then it shows correctly.

Please help to solve the problem.

bye
ayppa

I've moved this topic to the Excel forum instead of the general feedback forum. I don't know if the solution involves VBA (it might) but this is a more appropriate forum to get the right answer, even if it isn't the perfect match.

Jim Minatel
Senior Acquisitions Editor
Wiley Technology Publishing
WROX Press
Jim's Book of the week: ASP.NET 2.0 Beta Preview