Exporting to excel

  • Thread starter Thread starter cameljs18
  • Start date Start date
C

cameljs18

I am using RKLib to export to excel but i need to change the format of
one of the columns when i export it to excel.Any suggestions will be
appreciated, when the column is opened by excel it is automatically
converted into rands because there is a R before the data in each
cell.Is there a way i can send it through in a text format so excel
leaves it just as it is. thanks
 
I can't remember if it works via code or not but in excel itself you
put a single quote before your data to make it read as text.

'0001
 

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

Simple Methods to Export Gmail to Text? 1
Best Ways to Convert OST to PDF? 3
C# export excel chart to image and send it an email 5
How to Convert EML to PST files? 1
Word to Excel: Export comments with text and line number 0
Excel And C# 4
export data 1
How Can I Convert MBOX to HTML File? 0

Back
Top