I'm working with a set of numbers that are 9 digits long but are not social security numbers so I don't need the dashes. However, some of my numbers may have zero's at the beginning. When I type the 0 number it automatically hides the zero. How can I get the number to show?
For example
Number 005121111 shows as 5121111 but I need the zeros.
Any help would be greatly appreciated!!!!