Home › Discussions › Questions & Answers › Retaining Leading Zeros in CSV Output
Customer · · Questions & Answers · 3 replies
Excel is treating my alphanumeric serial numbers as pure numbers when opening CSV output, causing leading zeros to be lost. I need a robust workaround.
To prevent Excel’s automated type detection, you must modify your SQL to explicitly format the column as text by prefixing it with an equal sign and enclosing it in double quotes: ‘=”‘ || column_name || ‘”‘ column_alias.
If I apply this modification to my SQL, what happens if I run the report in XLSX format instead of CSV?
If the report runs in XLSX output format, Blitz Report automatically removes the =” and ” characters from the data, ensuring the data displays correctly without the formatting characters.
Sign in with LinkedIn or Google to take part.
