<div>
1. I am currently formatting it using a quote but actually that is also incorrect. If someone wants to load that excel directly that quote will be an issue.<br />
<br />
2. I am not sure if I can use any formula while export html to excel.<br />

</div>


1. I am currently formatting it using a quote but actually that is also incorrect. If someone wants to load that excel directly that quote will be an issue.

2. I am not sure if I can use any formula while export html to excel.


<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
I am trying to export some data which is in numeric format with 0 as prefix to few of the values as below.<br />
<br />
01<br />
02<br />
03<br />
34<br />
56<br />
<br />
When I export this data to excel, it is changed to<br />
<br />
1<br />
2<br />
3<br />
34<br />
56<br />
<br />
How do I keep '0' in place. Currently I am prefixing this data with a quote, but I guess there should be a better solution.<br />
For export I am creating an HTML and exporting it as xls.<br />
<br />
Let me know if any more info is required.
</div>
</div>


Hi Experts

I am trying to export some data which is in numeric format with 0 as prefix to few of the values as below.

01
02
03
34
56

When I export this data to excel, it is changed to

1
2
3
34
56

How do I keep '0' in place. Currently I am prefixing this data with a quote, but I guess there should be a better solution.
For export I am creating an HTML and exporting it as xls.

Let me know if any more info is required.

Numeric varchar - Export to Excel

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.