yes, that works.........many thanks

"GregNga" wrote:

Sorry, I didn't see the "PASTE SPECIAL" part, let me try it

"T. Valko" wrote:

Excel is a real pita when doing this!

Pre-format the destination cells as TEXT then use Paste SpecialTextOK

--
Biff
Microsoft Excel MVP


"GregNga" wrote in message
...
Whenever I copy and paste the following column into Excel
64082153021072309
17501818699072309
40310967596072309
07470568444072309

it is displayed as

64082153021072300
17501818699072300
40310967596072300
7470568444072309

How do I get Excel to display this without rounding up and trucating the
leading zero.