View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Me Me is offline
external usenet poster
 
Posts: 4
Default 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