Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Leading Zeros | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) |