Hi there,
I have a column of "auto-incremented" serials with a custom number format '00' which gives me the values 01, 02, ...,10,11, etc. What I want to do is to use the whole value (with the leading zero) in concatenation with other values. Using the cell address as a reference in the concatenation, I get the leading zero of the values 01-09 removed > 1-9 (as they are treated as numbers).
So, how can I get the "text value" of the serial so that I can use it with the leading zero(s)?
Thanks in advance for your help
Bookmarks