Hi, im new to this forum so hello.

Ive been searching around the net for a solution but of yet have not
found one, so hoping that sombody will be able to give me a hand. (im
making a binary to decimal converter for my work at college, i no how
to do the actual code to convert it im just trying to make it neat)

Im trying to split a number with leading zeros. Im using the mid
function to split out the number but for some reson it wont see the
leading zeros

ie spliting 00011110
im using =MID(b4,2,1) which should bring up 0 but its counting the
characters from the first 1.

ive sort of found a temorary solution by converting it to text, but the
imputer has to remeber to put leading zeros on so it makes it 8
characters.

is there any way to make excel add the zeros on (in a text field) to
make it up to 8 characters what ever the imputer puts in.

Any help is much appreciated as im not very good at excell (know more
about access, thats were i got the mid function) so please dont be to
complicated

Thanks in advanced

Helen


--
haitch2
------------------------------------------------------------------------
haitch2's Profile: http://www.excelforum.com/member.php...o&userid=27677
View this thread: http://www.excelforum.com/showthread...hreadid=471900