Y
Yellowbird
Hi,
I have a column containing a five digit Line Number value (string), as
follows:
00000
00001
00002
and so on. I need this value to be no longer than 4 digits in length,
so I need to trim the leading zero from the string in each cell so
that I will have:
0000
0001
0002
I understand that the TRIM function will remove a leading space from a
string value, but I can't seem to get it to work for the leading zero.
What am I missing?
Thanks in advance,
Yellowbird
I have a column containing a five digit Line Number value (string), as
follows:
00000
00001
00002
and so on. I need this value to be no longer than 4 digits in length,
so I need to trim the leading zero from the string in each cell so
that I will have:
0000
0001
0002
I understand that the TRIM function will remove a leading space from a
string value, but I can't seem to get it to work for the leading zero.
What am I missing?
Thanks in advance,
Yellowbird