Forum

Thanks for your responses. And I have to apologise, because the cells I need a zero in front of has 10 numbers ,not 9. the cells I don’t need a zer...

Thank you. this text formula works to add a 0 to all numbers, but not to the ones only containing 9 numbers. I don’t need a 0 in front of the cells w...