I need to pad a string to make it a max of 9 character's long with proceeding zero's, this needs to be done on the users input cells. The string should typically consist of a string of 6 characters, followed by a forward slash, followed by a trailing 3 integers. I need the string to consist of something such as 200/003 turn into 000200003 so the preceding zero's are filled and the slash is removed, any help or pointers would be greatly apricated.

Thanks in advance