Geek Answers Handbook

Export to csv / excel mode to include leading zero

Exporting the selected query data from mysql to csv and opening with excel, the leading zeros disappeared.

Although the column is varchar when data is exported, it is written as

4567 instead of 04567, Is there a way to keep the leading zero when exporting to csv?

+5
source share
4 answers

You need to wrap the number in double quotes, for example:, ...,"04567",...but then it will be interpreted as text in a spreadsheet, so integer arithmetic will not work on it unless you do the conversion first (integers cannot start with 0 in Excel).

-3
source

Put data between single quotes when exporting csv.

. 04567 '04567'

+1

SSRS, , , , . , 00000 . , Excel 2013.

+1

CSV . .

, Excel Numbers ( Mac) . , excel , . excel, - (.. ), . .

excel , -, - excel " ". XLS, , CSV.

0

More articles:


All Articles