importing phone numbers


I am trying to import a large phone list from a csv file, but when i do this it drop the first 0 in the number.

Is there a way to stop this happening?

Any help appreciated


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    It would look similar to the flagging formula above. If it is only dropping one zero then it would be as straightforward as

    =IF(LEN([Number Column Name]@row) <> 11, "0" + [Number Column Name]@row)

    If you are dropping multiple digits, then we would need to tweak it a little bit.