B
Billing Goddess
I would like to count the number of characters within a cell.
for example: the number 3456 within the cell - I want to return the value of
4, but if the number is 456, I want to count the number of characters and if
there are not 4 characters, I would like be able to add a zero at the
beginning of the number so that I will have 4 characters
for example: the number 3456 within the cell - I want to return the value of
4, but if the number is 456, I want to count the number of characters and if
there are not 4 characters, I would like be able to add a zero at the
beginning of the number so that I will have 4 characters