ctrl-c from excel to pb dw field

58 Views

I have an Excel file extracted from a datawindow and am trying to copy a cell into a field in a pb dw. This field is formatted as General and may contain 9 or 11 digits. When I copy/paste an 11-digit number it pastes into the field w/ no problems, but when it's < 11 digits the paste doesn't work. I tried modifying the Edit styles (from Edit to EditMask), but when I did this the problem was reversed (was able to paste the 9-digit number, but not the 11-digit number.

The other thing I had noticed is that if I just click on the cell in Excel, the paste works only on the 11-digit number. For the 9-digit number to work, I would have to highlight the entire set of digits from beginning to end.

I don't have this issue if I paste it from Outlook, Notepad, etc.

Has anyone ever encountered this problem?

Any help would be appreciated.