Forum Discussion
Solved
Custom Number Format that Allows Special Characters
Hi all, Is there a custom number format that can be used to allow wildcards or asterisks (*) in a phone number? Below is an example of the desired result. The numbers on the left are not formatte...
Adding a character such as * to a number changes it from a number to a text value.
Number formats only work for numbers, not for text values.
So what you want is impossible.
I'd enter the special character in the cell to the right of the phone number.
Adding a character such as * to a number changes it from a number to a text value.
Number formats only work for numbers, not for text values.
So what you want is impossible.
I'd enter the special character in the cell to the right of the phone number.