|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.