Adding Leading Zeros to Phone Numbers
Just imported a csv file to Filemaker Pro to populate a form and fields we finally managed to recover from Bento 1.
Sadly all the leading zeros have disappeared from the numbers.
They look like this:
298763542 instead of 0298763542
414188998 instead of 041488998
How can I use Filemaker pro to put them back.
Please be basic in your explanation. Today is the first day I have Filemaker pro on my own.
I have used a calculation like ="IF((LEFT,2),0,A1) to tidy all the numbers in excel is there a way to do something similar in Filemaker Pro 10?
Is there an even better way?
I hope so.