Export Datagrid

[Reggie]

Hi and TIA! I have a datagrid inside a panel control. I have a procedure
that exports the panel control and thus the datagrid to excel. The datagrid
has the following sample fields/data.

Nomen NIIN Qty
Key 000234567 2
Ring 002818181 3

The problem is that I loose the leading zero's. How can I update the
dataset to concatenate an apostrophe to the beginning of each NIIN value,
rebind the datagrid then export the panel as normal. Basically how do I
update the dataset? I don't want to concat the value in SQL view because I
have many views that use this export and I want the displayed value not to
show the apostrophe . Thanks for your help.

 

[Reggie]

Never mind got it figured out. One thing though. I was thinking(hoping)
that the apostrophe wouldn't show in the excel sheet. It disappears when you
type it directly into a cell in excel. Any thoughts?