on 2/18/2011, Rose Men supposed :
Hi ,
I have a record character variable which has less than 9 length,
I need converted to a 9 character text field with leading 0s.
how can i coded in MACRO so that I can automaticly transfer them to 9
length next time when I get more data to excel.
Thank you very much.
Rose
You could have Excel do this automatically by setting the target
cell[s] number format to custom, defined as:
00000000#
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc