jimmymac
Reputable Poster
We are on 9.0, tools 8.98.42.
We have a report that is defined to export to csv. However, I've just noticed that values that might have a leading zero, such as Tax ID or Zip code, when the csv is opened in Excel those leading zeros are gone.
I know its attribute of the excel columns I guess, but just changing the column formatting after its displayed doesn't do anything.
Anyone run across this before and have any suggestion on how to not lose those leading zeros?
Thanks.
We have a report that is defined to export to csv. However, I've just noticed that values that might have a leading zero, such as Tax ID or Zip code, when the csv is opened in Excel those leading zeros are gone.
I know its attribute of the excel columns I guess, but just changing the column formatting after its displayed doesn't do anything.
Anyone run across this before and have any suggestion on how to not lose those leading zeros?
Thanks.