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.