Format zeros
=SUBSTITUTE(A1,0,"")
"octet" wrote:
I have field that have numbers with zero,s like this 0002764357000 i would
like to
format the column so that the zeros before or after any number are not shown
does anyone know how to do this?
thanks
octet
|