Hello,
I was wondering if there was a way to paste 16 digit numbers into merged cells.
I have formatted the Cell as "Text" so the number doesn't get rounded off.
However, when I paste the number into the merged cell I get the prompt:
"Data on the Clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
Upon choosing "OK"
The following error is reported:
"Cannot change part of a merged cell"
I know that the number can be pasted by being within the cell.
The merged cells are AX7 through BT7
Thanks
I was wondering if there was a way to paste 16 digit numbers into merged cells.
I have formatted the Cell as "Text" so the number doesn't get rounded off.
However, when I paste the number into the merged cell I get the prompt:
"Data on the Clipboard is not the same size and shape as the selected area. Do you want to paste the data anyway?"
Upon choosing "OK"
The following error is reported:
"Cannot change part of a merged cell"
I know that the number can be pasted by being within the cell.
The merged cells are AX7 through BT7
Thanks