+ Start a Discussion

Format Phone data type value using data loader

First my Account object has custom Contact Phone field with Text(100) data type which has unformatted phone values then i change data type to PHONE data type.and i remove all account phone data with blank then update original phone data but still phone values in unformatted.

I try to change phone data manually in account detail page then i saw phone in right format.

Please help me i want this phone data in format ex.7603700404==>(760) 370-0404