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?
  • 2 Comments
  •     paola November 23, 2016 10:56AM
    Checking if zero is the leading character, than adding where it's missing:
    IF(STARTSWITH([Tel], "0"),
    [Tel],
    "0"+[Tel])


    Or similarly checking the length of the string:
    IF(LEN([Tel])=11,
    [Tel],
    "0"+[Tel])
  • aa1708 November 23, 2016 11:34AM
    Thanks Paola works great

Welcome!

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

Sign In Apply for Membership