why cant i copy from word 2010 and paste into

Microsoft Office 2010 professional
April 21, 2011 at 04:51:33
Specs: Windows 7 64 bit, 8200 mb ram
I have some numbers in an email I wish to paste into a cell in excel


this is one example

when I try to paste it into an excel 2010 cell the number initially comes across, then it immediately changes to

1.102E+19 and positions itself at the right hand side of the cell (formatted for left hand side)

then if you hold your mouse over the cell the following number appears

11020002706698800000, although this is only visible while hovering, it disappears and goes back to the 1.102E+19 number if you click out of the cell.

I can type any number or letters I want in the cell

the paste actually works, if I write something before hand

like: serial number 11020002706698805439, then the paste stays intact.

the same thing happens if i try to paste out of word.

The only way it has worked is to place it in a text box, which is not really helpful if I need to to calculations.

I have tried it in excel documents originally designed in office 2007, and i get the above,
so i immediatly tried creating a new document in office 2010 and the exact same thing happens.

The above strange entries, also happen to be the exact same entries, and the excel 2010 formatting examples, which seems rather weird.

And to top it off, the packet on my office professional 2010 says 1 year technical support,
when i tried to email my question, microsoft tells me it isnt supported.
Its the evening before Good Friday, and the Microsoft help desk is not available until Wednesday next week. Hehehehe, which will probably mean Friday next week, before I wont get the busy signal.

See More: why cant i copy from word 2010 and paste into

April 21, 2011 at 07:08:07
Format the cell as Number...0 decimal places after the paste.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

April 21, 2011 at 12:25:21
Excel supports a maximum of 15 significant digits, that's why when you enter:

   serial number 11020002706698805439

It will accept the number, because it reads the whole STRING as TEXT.

Putting just the number in a cell will give you the notation 1.102E+19



Report •

April 21, 2011 at 18:09:12
Thank you Mike

Report •
Related Solutions

Ask Question