You’re offline. This is a read only version of the page.
60
I would like to change GP so that it will properly format the phone number copied from Excel and pasted into GP.
I often copy phone numbers from Excel to paste into GP. The phone numbers are of a 'standard' format'; i.e.: 555-123-4567. When I copy (text only) and paste the information into GP, it ends up looking weird. For example, the above number will end up looking like this: (555)-12-3-45 Ext. 6700.
If, however, I format the number as: 5551234567, it will be correctly formatted when pasted into GP. Formatting like this isn't difficult, but it does make the phone numbers difficult to read in Excel.
Help!
*This post is locked for comments
I have the same question (0)
This behaviour is by design of the Dynamics GP product. Even though you see a number formatted like "(XXX) XXX-XXXX Ext. XXXX", Dynamics GP is really storing it in SQL as "XXXXXXXXXXXXXXXXXXXX". Since we are an International company we have removed the "mask" and store telephone numbers in any format we want (but only up to 20 characters). Its a small point, but I do wish Microsoft would change the phone numbers to a more International capability (rather than the North American centric behavior in place now).
I don't think there's an easy solution. Probably something in Dexterity that senses the Paste operation and filters anything that's not a number out.
Tim
Share
Report
All responses (
Answers (
