Retain leading zeros in CSV (simple solution) (webdigi.co.uk)

I don't understand why Microsoft Excel removes leading Zeros if a column in "0058"? In open office the column is correctly displayed as 0058! This is without having CSV data changed to +"0058".

or use a dedicated csv editor. i use CSVed.

It depends on what program one uses for opening CSV i guess .. If the users are only going to use EXCEL, it makes sense to add an extra = in the exports .. if not, that's again an issue ..

also, CSV format dictates that it should be "=""000123""" ..

or just import it as .txt file and treat the column with leading zeroes as text ..