![]() |
Formatting a cell
Hi all
Using VB, I created a new sheet. I would like to format a certain column so when my VB program put numerical values starting with zero, the zero would stay. Example: "01234" should read "01234" when the file is opened with Excel. At the moment when I open the file with Excel, the reading is "1234" (the leading zero is omitted) Maybe I should format the column as "Text" How do I do that please? TIA Guy |
All times are GMT +1. The time now is 10:39 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com