Copying data with decimal points changes numbers to 1.

Dawid Nawrot

I'm copying data from Excel to a table but numbers like:

 

7.94

5.12

are automatically changed to a numbered list 1.94 and 1.12

I can't copy using CTRL+SHIFT+V because then the data won't go into the cells properly. Can we disable this automatic list? It's a terrible experience!

Mike Bowen

Hi @Dawid Nawrot 

When you say you are copying data from Excel to a table, are you simply copying a couple of rows in your Excel and then dropping them into a blank page, which auto creates the table or are you copying into an already defined table? 

I ask because I just copied a couple of rows from a sheet in Google & Excel with numbers containing decimals and pasted into a blank page. It worked just fine. 

I also copied and entire column of decimals, and it auto-created a table with all the values in it. 

I also copied the decimals and overwrote my cells in a table and they too copied okay. I am not experiencing what you are experiencing.

I use Right Click Mouse and Paste - works perfectly,

I also tried CTRL+V to paste - works perfectly. 

-Mike