Visokio website     Downloads     Video tutorials     KnowledgeBase  
Data Validation: Adding Leading Zeros - Visokio Forums
Data Validation: Adding Leading Zeros
  • aa1708 November 23, 2016 10:45AM
    Hi there, I have a column with hundreds of phone numbers but some records don't have leading zeros. Is there a way to construct a formulae to add zeros to the ones without?
  •     paola November 23, 2016 10:56AM
    Checking if zero is the leading character, than adding where it's missing:
    IF(STARTSWITH([Tel], "0"),

    Or similarly checking the length of the string:
  • aa1708 November 23, 2016 11:34AM
    Thanks Paola works great


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership