Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Spliting a number with leading zeros
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CSV File - Leading Zeros | Excel Discussion (Misc queries) | |||
Is it possible to show leading zeros for "number" cells? | Excel Discussion (Misc queries) | |||
How do I force leading zeros in an Excel cell? | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) | |||
Leading zeros | Excel Discussion (Misc queries) |