Find/Replace strips out zeros

Originally Posted by outofthehat

For future reference, use =SUBSTITUTE(A2,".",""), which removes the period(s) from A2 and leaves the answer as text.

Thanks for that. Be up in Nottingham later this year - my sister lectures at N/T Uni. Nice place.