Sorry to interrupt with a technical question, but I don't know where else to ask this.
The situation is that my app creates a tab-delimited text file, which I want to 'open with' MS Excel. The problem is that one of the cells contains a long
string of binary data (e.g., 01010101111111100000000010101010101000000000001111111110000011). I cannot find a way of making it display correctly though when I open the file in Excel.
When I open the file in Excel, it either shows as...
1.1E+198
...or as...
1010101111111100000000010101010101000000000001111111110000011 (with the leading zeroes missing - which is no good)
If my app writes the data into the file with an apostrophe in front (e.g., '01010101111111100000000010101010101000000000001111111110000011) then the apostrophe also gets displays in Excel.
How can I make it so that just the 01010101111111100000000010101010101000000000001111111110000011 shows when I open the file in Excel (preferably without having to modify loads of cell properties)?!
Thanks in advance,
James