I have a column that contains 1021 cells that all have numeric values. I need to add a ZERO (0) to the front of each of these values so that my custom format will work correctly.
These numbers vary in length from 10 to 14 characters. Ultimately I need number "333954623578" to look like "00333-954623578" and I have a custom format of "00000-000000000" to make it work, but for some reason "333954623578" won't format correctly but "0333954623578" will work like a charm...? Any ideas?
Thanks in advance!
Bookmarks