Hi Folks,
I got some awesome help recently and this formula as a result
=IF(LEFT(A3,1)="0",RIGHT(A3,LEN(A3)-1),A3)
It worked great to strip the left most zero from a string of text numbers in the cells where the formula was applied.
However, now I need to put the zero back in lol!
So...how would I adjust the formula (or write a different one) to insert a zero as the first digit of a string of text digits?
Many thanks!
Bookmarks