Hello guys
anyone able to help out with a small problem i have
i have a whole row of numbers that contain a letter in each line e.g
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
3478L1
1357L1
what i would like to do is add 2 zeros to the beginning of each number eg
003478L1
001257L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
003478L1
001357L1
guys i have tried right clicking on A1 the selecting format cells then number then custom and entering 000000
this works ok for a standard 6 digit number but mines contains a letter L and thus cause this formula to fail
does anyone have have any ideas how i would get 2 zeros to the start of each number please
many thanks
Gary
Bookmarks