ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting the values to excel error (https://www.excelbanter.com/excel-discussion-misc-queries/264927-exporting-values-excel-error.html)

karthik

Exporting the values to excel error
 
Hi All,

I am trying to exporting the values as '10-02' and '10-03' from my developed
application (developed in .Net). These values are stored as 02-Oct and 3-Oct
respectively.

Can anyone throw some light on this?

Thanks,
Karthik

Sheeloo

Exporting the values to excel error
 
You need to add ' before the numbers... since they represent dates Excel
converts them into dates...

If possible export them as '10-12 instead of 10-12

"Karthik" wrote:

Hi All,

I am trying to exporting the values as '10-02' and '10-03' from my developed
application (developed in .Net). These values are stored as 02-Oct and 3-Oct
respectively.

Can anyone throw some light on this?

Thanks,
Karthik



All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com