So, I’m trying to import my Perl-generated file as a CSV into Open Office. Apparently, if the data coming into a cell is of the form “D.D.D” where “Ds” are digits, it obviously and absolutely must be a date, and it converts the incoming cell to that format.
Well, no. I wanted it to be (for example) literally “1.3.5.” Really. No kidding. It’s not 01/03/05. But it won’t let me do it.
I don’t want to have to manually go in and change the format for each cell where this happens, and even if I did, there’s no obvious way to do it and retain the original info without manually retyping the number with a single quote in front. Is there an Open Office guru out there?
BTW, I really appreciate the help with the Perl problem. It was invaluable (which means, it was very useful, but I don’t know how to pay for it, or what it was worth to those providing it).