Helen Pereira 26.Apr.06 05:07 PM a Web browser Domino Designer 6.5.5 Windows XP
I'm trying to run an import into a db from an excel file. The phone numbers on the excel spread sheet are listed in the (123)-456-7890 format. When I try to import, it errors on the phone number field saying text expected. I changed the formula in the field to @Text(fieldname). It will import the phone numbers with the @Text, however, it does not put in the dashes between the phone numbers; instead displays it in the view as 1234567890.
How do I fix it so it puts in the dashes? Is there a formula that will do this?
Thanks for any suggestions