Exporting the values to excel error

K

Karthik

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
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel check if dates are under a range of week 4
Using VBA to create charts 1
Adding Filtering to a Rating Equation? 0
Formula error 4
Using Office Forms and dynamically updating the excel backend 0
Macro in Excel 2
Pivot Table? ID, Date, Value sorting 4
If Function 1

Top