One solution is to changes the leading zeros to upper case letter O. Not an ideal solution, but .... the problem is with the CSV formatter, which treats zip codes as an arithmetic number, where leading zeros have no arithmetic value, so they are omitted.
On Mon, Apr 12, 2021 at 11:47 AM Kristi Nelson <kristinelso...@gmail.com> wrote: > Hello. I have a csv file that I am trying to edit in openoffice so the > leading zeros (for zipcodes) in the file appear. I am able to get that > accomplished in open office, but once I save as a csv file again, it > reverts back to the original file where they are hidden. Can someone please > help me with this? > > Thank you! > Kristi N. > kristinelso...@gmail.com >
