Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
385
Mask input for phone
posted

According to the documentation, a mask of (999) 000-0000 would show parentheses surrounding 3 optional numerals and then 7 mandatory numerals. This doesn't work at all, it shows the first 3 numerals followed by 7 zero's. using combinations of 9's and pound signs still fills the parentheses first and leaves unused mak at the end.

 I have a column that is saved as text, either 7 or 10 numerical characters. If there are 7 I want them displayed as "() 555-1212" and if there are 10 I want "(555) 555-1212".

 Thanks for your help.

Bob

Parents
  • 469350
    Offline posted

     Hi Bob,

        I'm not sure where in the help you are looking, but my guess is that the help topic in question assumes that the value of the cell is numeric, not string, since 9 and 0 are numeric mask characters.  

Reply Children