AngelSpeaks
Well-known member
- Local time
- Today, 12:03
- Joined
- Oct 21, 2021
- Messages
- 693
Importing from Excel can save a lot of time, but cause a lot of headaches. The first spreadsheet from client used the format xxx-xxx-xxxx for the telephone number. Now they are using (xxx) xxx-xxxx. Is there a way while transfering the spreadsheet that this column can be formatted to one layout? The telephone is to be exported to a csv file to upload to a State portal. They want either xxx-xxx-xxxx or all numeric for that column. I would like format to be the same for all rows in my table.
Thanks
Thanks