pasting zero '0' into excel, not loose the number 08459 to 8459
 

pasting zero '0' into excel, not loose the number 08459 to 8459
 

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

pasting zero '0' into excel, not loose the number 08459 to 8459
 

... before copy pasting

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