leading zeros!!!! arrrrrrgh! please help
 

hello,

i've been searching for (literally) 3hours on the web... apparently i'm the
only one ever to have encountered this...

i want to put a value of "0204" in a cell via vb. short story.... can't.
it's "204". always.

i need a way to have excel format the cell as text.... please for the love
of humanity.... anyone know how to do this? i'ts vb6 and excel 2k3

any help would be GREATLY appreciated

dushan

leading zeros!!!! arrrrrrgh! please help
 

Hi Dushan,

Try to use a custom format in XL2003... along these lines:
0########
or in VBA use:
Range("Whatever").NumberFormat = "0########"

Should work orright...

Cheers,
spIky haIred