Excel - VBA text formatting
I'm trying to format the text of a TextBox into SSN format ###-##-####. My code looks like this .Text = Format(.Text, "###-##-####").
It works everytime until the leading character is a zero. If I enter 012345678 it will drop the leading zero. How do I prevent this?
It works everytime until the leading character is a zero. If I enter 012345678 it will drop the leading zero. How do I prevent this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER