Hi.

There is a file that we want to export to a CSV file, but it is changing the
format of things that look like numbers.

It should export some of the numbers in a 5 digit format... 01000 , 01001 ,
etc.

We tried changing the cell format to text, and using the formula
=text(a1,"00000") and changing that to values...

Either way, in the .CSV file, it still came out as 1000 , 1001 .

For now, I did what was needed by creating a simple text file with the output.

But, is there anyway to keep the leading 0 s on things that look like
numbers, in a CSV file?