Thread
:
Format Column to display leading zeros.
View Single Post
#
4
Posted to microsoft.public.excel.programming
Peter T
external usenet poster
Posts: 5,600
Format Column to display leading zeros.
as text -
rng.NumberFormat = "@"
Regards,
Peter T
"Glenn Buchanan" <Glenn
wrote in message
...
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
Reply With Quote
Peter T
View Public Profile
Find all posts by Peter T