I did that and it worked, but when I save it as a csv again, it reverts back to keeping off the leading zeros. I need the file to be saved as a csv for the program we are using. How can I keep the formatting as text?
On Mon, Apr 12, 2021 at 1:06 PM JACKSON <[email protected]> wrote: > Try formatting the cells containing zip codes as text. > > > On Apr 12, 2021, at 1:13 PM, Kristi Nelson <[email protected]> > 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. > > [email protected] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > >
