Formatting a cell
Hi all.
I use VB6 to create an Excel file.
I have a recordset with text value (e.g. "03") which I populate to the Excel
file.
When I open the Excel file, the value is "3" only without the "0" prefix.
I tried :
xlsSheet.Cells(R,C).NumberFormat = "@"
The original number format was "General" (I quick-watched it).
Please advise
Guy
|