Pasting 16 digit number into merged cells

jay-excel

New Member
Joined
Aug 20, 2009
Messages
34
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
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

TFCJamieFay

Active Member
Joined
Oct 3, 2007
Messages
480
Hi,

Can you Paste Special - Values only?

HTH,

Jay

Edit: This doesn't work, try opening the cell with F2 and then paste your number. I tested this and it worked fine for me. Jay
 
Last edited:

jay-excel

New Member
Joined
Aug 20, 2009
Messages
34
Hello,

Thank you for the reply. I was aware of pressing F2 and then pasting, and it does work :)

However, I was wondering if there was a way to format the merged cells so that the 16 digit number could be pasted by pushing Ctrl-V or right-clicking the cell and choosing Paste.

Thanks so much.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,710
Messages
5,597,702
Members
414,164
Latest member
ARTW

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top