000BAB0C5798 |
000BAB0F19FF |
3064097340 |
000BAB0D804C |
000BAB0C54E0 |
000BAB11BA68 |
000BAB0F1EC8 |
000BAB0D8032 |
3.06E+16 |
000BAB0DA991 |
Here is a sample of data I'm exporting to an Excel file. How do I get the values that just contain numbers to export as text?
FOR EACH tmpRecView:
PUT STREAM sRptFile UNFORMATTED
tmpRecView.addr-mac
FORMAT "XXXXXXXXXXXX" SKIP.
END.
Thanks,
Andy
If that is exactly the way you are writing to the file, then the problem is with Excel's "automatic recognition" kicking in and applying a different default style to input that appears numeric than that which appears to be non-numeric text.
If you need to solve this problem at the time of creating the raw file, then you can either use SpreadsheetML (if you are using 2003; else it will be Office Open XML) or HTML to explicitly tell Excel how to format the text.
Check out http://www.oehive.org/TempTableExpositor and http://www.oehive.org/project/OOCalcLib and http://www.oehive.org/project/libxlsx