in reply to Re: Long integers in Spreadsheet::WriteExcel
in thread Long integers in Spreadsheet::WriteExcel

Problem is I get 1.00000000000265e+15 as output which is still not good for me.
  • Comment on Re^2: Long integers in Spreadsheet::WriteExcel

Replies are listed 'Best First'.
Re^3: Long integers in Spreadsheet::WriteExcel
by Corion (Patriarch) on Aug 09, 2011 at 09:10 UTC

    When needing to write looong identifiers that look like numbers into Excel spreadsheets, I usually prepend a space to them, so that Excel "knows" that they are strings.

      OK, this seems like a good and simple solution. Thanks for your help!