Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming |