in reply to Re: Not sure why perl-generated spreadsheet has formatting issues
in thread Not sure why perl-generated spreadsheet has formatting issues
Hi Athanasius, I've tried the code but the output is still the same. Is it possible for me to send you the output file I was able to generate?
If I highlight the cell, it shows the formatting I want. But if I generate a pivot table from that, it will still cause me problems when I try to group the information.
The only solution for me at this time is to double-click each cell, then press "Enter" in order for the data to be displayed and treated correctly :(