excel macro
 

Hi ,
I have a record character variable which has less than 9 length,
I need converted to a 9 character text field with leading 0’s.
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

excel macro
 

"Rose Men" wrote in message
...
Hi ,
I have a record character variable which has less than 9 length,
I need converted to a 9 character text field with leading 0’s.
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

check out Format function
format(1,"00000000#")
format(12,"00000000#")
format(123,"00000000#")
format(1234,"00000000#")
etc
hth
mark

excel macro
 

On Feb 18, 1:44*pm, "mp" wrote:
"Rose Men" wrote in message

...
Hi ,
I have a record character variable which has less than 9 length,
I need converted to a 9 character text field with leading 0 s.
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

check out Format function
format(1,"00000000#")
format(12,"00000000#")
format(123,"00000000#")
format(1234,"00000000#")
etc
hth
mark

Can i write a code in a sub function using VBA to do it automaticaly?
thanks,
Rose

excel macro
 

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

excel macro
 

"Rose Men" wrote in message
...
On Feb 18, 1:44 pm, "mp" wrote:
"Rose Men" wrote in message

...
Hi ,
I have a record character variable which has less than 9 length,
I need converted to a 9 character text field with leading 0 s.
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

check out Format function
format(1,"00000000#")
format(12,"00000000#")
format(123,"00000000#")
format(1234,"00000000#")
etc
hth
mark

Can i write a code in a sub function using VBA to do it automaticaly?
thanks,
Rose

Yes of course, but go with GS's suggestion...it's much better than mine
you won't even need to write and call a macro that way.
mark

excel macro
 

Rose Men pretended :
On Feb 18, 1:44*pm, "mp" wrote:
"Rose Men" wrote in message

...
Hi ,
I have a record character variable which has less than 9 length,
I need converted to a 9 character text field with leading 0 s.
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

check out Format function
format(1,"00000000#")
format(12,"00000000#")
format(123,"00000000#")
format(1234,"00000000#")
etc
hth
mark

Can i write a code in a sub function using VBA to do it automaticaly?
thanks,
Rose

Nothing you write in VBA will work as well, fast, or efficient as
Excel's built-in features.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc