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 <robertjack...@rogers.com> wrote: > Try formatting the cells containing zip codes as text. > > > On Apr 12, 2021, at 1:13 PM, 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 > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > > >
