Cvt number to character
Place in a helper column:
=TEXT(A1,"000")
Copy/paste special - values in the Helper column
"GKW in GA" wrote:
Hiow can I convert a column of numbers from numeric to character and pad with
2 zeros
e.g. I want the number 1 to appear as character 001
|