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