| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Threaded Mode
