From your subject line ..
pasting zero '0' into excel,
not loose the number 08459 to 8459

Try pre-formatting the cell(s) / col as Text before copy pasting
(via: Format Cells Number tab Text OK)

P/s: Always enter your query within the message area (the whitespace), do
not leave the message area blank. The subject line is supposed to contain
just a key description of your query, not the entire post <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"diamonde" wrote in message
...

... before copy pasting

should read as:
... before copy pasting special as values
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---