AnsweredAssumed Answered

Adding Leading Zeros to Phone Numbers

Question asked by DAM on Mar 6, 2009
Latest reply on Mar 6, 2009 by vcirilli

Title

Adding Leading Zeros to Phone Numbers

Post

Hi,

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

or

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.

Cheers 

Outcomes