Well I'm doing a query with php to an Oracle Database... the result is show on a excel file...
the problem is that I have a number compose with two fields

I made it like this TO_CHAR(CONCAT(TO_NUMBER(cua.CAP_RA,'9999999999'),TO_NUMBER(cua.CAP_NA,'9999999999'))) Cod_Rana, then... the others...

but I recieve on excel 1,21865E+15.... or if I put it like number... like this 1218650000000000... the issue is that this number is not the real number that I recieve when I do the query without php or excel... I recieve 1218650000154327123...
One field is 1218650000 and the other is 154327123 when I export this it cames other number... :/

SOS....
sorry for my English

    How are you exporting it to Excel? Sounds like you need to tell it to treat that field as text, not as a number.

      NogDog;11041997 wrote:

      How are you exporting it to Excel? Sounds like you need to tell it to treat that field as text, not as a number.

      yes, But I'm not sure how to do that...

        Putting it in quotes doesn't work? Though I do seem to recall that Excel is kind of insistent that it knows better how to interpret data. Could be something to do with the fact that it's for spreadsheets rather than databases.

          I think the way you are exporting it is not correct, describe how you are exporting this file?

            Write a Reply...