Hi there i've been given an assignment to design a spreadsheet which can convert Octal to decimal and back and do the same for hexidecimal. I know about the functions which do this for you but im not allowed to use these. i can design something but im not sure what happens when you get a four digit hex number and what is the largest hex number u can have in one string?

Thanks Nex