I'd like to store numbers as strings. But when I do this:
The cell is set to "120". I've tried:
but that doesn't seem to work either. It seems like
would be a good solution. But the length of the string can fluctuate (and this has to work for a client, who is tech illiterate). For example, there's a chance that when the client downloads the XLSX file, they'll want to change the string from a 5 digit
to a 6 digit number, and then they'll blame me that the XLSX isn't letting them (if their number has leading zeros) ...
I've been reading through the documentation, and I've searched the discussions, but I don't see a solution. Any ideas? I see that in Excel, the cell's formula is '00120 (with a leading '). Is this the solution? How do I do it?