Posted to microsoft.public.excel.programming
|
|
Format Column to display leading zeros.
Look he
http://support.microsoft.com/kb/81518
"Glenn Buchanan" wrote:
Using an external program with a language very similar to VB I have a script
that uses CreateObject to create a new workbook and fill with data. All well
and good. I have one column that is filled mostly with numbers where I need
to see any leading zeros.
How would I format this column before filling it? Changing the format after
the data is entered results in missing leading zeros.
With xl
.ActiveSheet.Columns("F:F").NumberFormat = ?
Regards,
Glenn
|