从数据表导出时，将数字格式设置为Excel中的文本格式 [英] format numbers as text in excel when exporting from datatable

问题描述

我有一个数据表，其中一个列值为0123、1234等.
当我将数据表导出到excel 0123时，值仅显示为123.如何在Excel中将数字设为0123?

谢谢.

Hi,

I''m having a datatable with one of the column values as 0123,1234,etc.
When I''m exporting the datatable to excel 0123 value is displaying as 123 only. How can i get the number as 0123 in excel?

Thank you.

推荐答案

查看以下链接:

http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVAndExcel [^ ]

Look at this link:

http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVAndExcel[^]

这篇关于从数据表导出时，将数字格式设置为Excel中的文本格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！